We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

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.