How to write where clause in database join to check if work notes CONTAIN 'value1' or 'value2'

[Snehal13]

How to write where clause in database join to check if work notes CONTAIN 'value1' or 'value2'

[Mayur2109]

Hi @Snehal13 ,

Please refer below post.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0719186 

Please check and Mark Helpful and Correct if it really helps you.

Regards,
Mayur Shardul

ServiceNow Rising Star 2024

[Snehal13]

I checked the article but want to avoid using script query to achieve the requirement. Thanks 

[Mayur2109]

Hi @Snehal13 ,

Can you please elaborate what exactly you want to achieve.

Regards,

Mayur

[Snehal13]

i need to get all incidents (along with category, state fields) whose work notes CONTAIN 'executed the script' or work notes contain 'deployed the script'