Error message Special characters (Unbalanced Expression)

[HidayatLalBaz]

Hello, everybody,

I hope you can help me out.

I want to create a report and search for a string in a special meta field (user.agent). The string contains several special characters: %, /, \, ), $, =, (

For example:
user agent contains 'Mozilla/5.0=(compatible; MSIE 9.0; Windows/ NT 6.1; \WOW64%; Trident/5.0''

When I enter the query into the Where text field in the report, I get the following error message:

Unbalanced Expression

How can I search for the string with the special characters?
The equals sign and the open parentheses always generate an error message.

Thank you for your help.

Many greetings
Hidayat

[NaushadKasu1]

Hello Hidayat,

Can you try to re-run the query with the single quotes around your value? For example:

user.agent = 'some data with an = sign'

[HidayatLalBaz]

Hello Naushad,

thank you for your answer.

I still get an error message, even if I put a quotation mark around the special characters.

If I put one or two backslashes before the special character, I still get the same error message.

Many greetings
Hidayat

[NaushadKasu1]

Hidayat,

I just caught in your message that you are experiencing this issue on the Reporting Engine. The "tooltip" in red is just a suggestion and I believe has some bugs in catching the "right syntax". There is an open ticket on it however, the query will/should still run for you. Can you try running the query using "Test" by testing the rule? I tested in my environment and it appears to be working. See image below as an example that ran in my environment but the Reporting Engine syntax checker thinks there is an error...

[HidayatLalBaz]

Hello Naushad,

thank you for the advice. You were absolutely right, the report can also be executed with the error message.
Thank you for your support and quick help.

Kind regards

Hidayat