CAN WE USE "CONTAINS" OR "LIKE" OPERATOR IN WHERE CLAUSE OF DATABASE VIEW

[sajan0192]

I have written following query

q_search.search_term = interaction.short_description

q_search.search_term(this field is from "ts_query_kb" table)

interaction.short_description(This field is from my custom table)

[larstange]

Not according to the wiki:

The Where clause supports these JavaScript conditional operators:

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

Database Views - ServiceNow Wiki

[sajan0192]

Hi Lars,

Thanks for replying....I know we can use above operator but I cannot achieve my requirement using these operator.

Can we use "CONTAINS" or "LIKE" operator??

[larstange]

Can you describe your need for this, maybe we can find an alternative solution

[sajan0192]

Hi Lars,

I resolved this issue.

I achieved my requirement by creating a Report and I called the script include in one of Report's condition.

Thanks for replying.

Sajan