Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to use 'CONTAINS' or 'LIKE' condition to join two tables in database view

ashwanikumar
Tera Expert

Hi All,

How can I add 'CONTAINS' or 'LIKE' condition to join two tables in database view?

Thanks,

KUMAR

 

1 REPLY 1

asifnoor
Kilo Patron

Hi,

As per ServiceNow documentation, the where clause supports only the below provided conditionaoperators.

Ref: https://docs.servicenow.com/bundle/jakarta-performance-analytics-and-reporting/page/use/reporting/ta...

The Where clause supports these JavaScript conditional operators:

=, !=, <, <=, >, >=, &&, ||

Mark the comment as a correct answer if it answers your question.