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

Take into account _ in a like condition on saved query

edited Apr 17, 2025 7:50AM in Transportation Management 8 comments

Summary:

Is it possible to add an escape character when filtering a field using contains in a saved query ?

Content (please ensure you mask any confidential information):

When adding this condition in a query ⇒

WHERE mycolumn LIKE '%\_%' ESCAPE '\'

it works well, but it is not possible to add this same condition at the level of a saved query configured in the UI

The goal is to take the underscore into account in the filter

Version (include the version you are using, if applicable):

25A

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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