What's new in Customer Journeys?

Connect and learn more!
Can't get LIKE operator to work if there's a space — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can't get LIKE operator to work if there's a space

Accepted answer
edited Sep 26, 2018 3:56PM in Reporting & Analytics for B2C Service 5 comments



I'm trying to set up an alert on a custom report to fire if the incident thread contains "customer data". I'm using the filter incidents.search_thread like %customer data% but it's not finding any incidents when I know there are some. 

It's working if there's not a space, for example incidents.search_thread like %bitcoin%

Is there a limitation that means you can't use the 'like' operator to search for strings with spaces? If so, does anyone have any tips how I can get around this some other way please?

Thanks in advance

Chris Carter

William Hill

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!