L3 - Default Steps to reproduce:
1) start a process instance with a variable foo and the value bar_123
2) login into cockpit
3) go to the runtime process instance view of the specific process instance
4) search for the variable inside the variables tab by using this query:
foo like "bar\_%"
Problem:
The variable foo is not returned.
Expected Behavior:
The variable foo is found.
Hint:
The following sql statement does not return the variable
select * from ACT_RU_VARIABLE where TEXT_ like 'bar\_%'
When the sql statement is changed as follows (ESCAPE '\' has been added):
select * from ACT_RU_VARIABLE where TEXT_ like 'bar\_%' ESCAPE '\'
then the variable is found