Search variables with underscore on Cockpit

Camunda 7 Topics Discussion & Questions
,
1

Hello,

We are using Camunda version 7.18.0.

There are some variables starting with T_ that we created in Process.

2023-02-20 10_09_53-Window

Of course, there are other variables that do not start with T_. But when I want to filter only those that contain T_ among all variables, variableName like ?? query cannot find any results.

2023-02-20 10_14_34-Window
2023-02-20 10_14_34-Window751×131 8.53 KB

When I search with another string in VariableName without _ (underscore):

2023-02-20 10_18_32-Window
2023-02-20 10_18_32-Window755×223 15.7 KB

Is it something with the Camunda version we are using?
Are we doing it wrong while creating the query?
Is _ (underscore) a special character when searching on Cockpit, if so how can we escape?

Thank you.

1 Like
2

_ is a special character in SQL ‘like’ query, meaning “any one character”
How to escape it might depend on which database engine you’re using.

3

Camunda is on MSSQL Server and [\\_] seems to work.
Thank you for your answer @GotnOGuts

4