How to escape special characters in Analytics

[sbsharma]

We are trying to find all the entitlements in the system, for a given endpoint, which starts with a specific keyword e.g. "ABCD_"

ev.ENTITLEMENT_VALUE like 'ABCD\_%'

This query is working fine in data analyzer and generating the desired output. But, there are more than 100 records so we are trying to create analytics with the same query.

But, we are getting following error.

"An internal error occurred. Please check supported special characters next to query field in (i) icon and remove the unsupported characters."

Can you please let me know how to make it working in analytics?

[nimitdave · Accepted solution]

Please try once with INSTR function also. Meanwhile I will check on the supported special characters.

[dgandhi]

Hi,

Can you paste the entire query so that we can check?

Thanks

Devang