NOT LIKE doesn't seems to match Empty values

[Sidney-]

Hi everybody,

This is regarding querying the REST API.

First of all I know about the ISEMPTY operator but.. I was kind of expecting NOT LIKE to match empty values as well for string values?

I mean if I filter on short_descriptionNOT LIKESQL any short_description that does not have SQL in the name (like an empty one) should match this as well should't it?

Anyone have some insights in this?

Thank you.

Best regards,

Sidney

[Anil Lande · Accepted solution]

Hi,

As per OOB configurations ServiceNow operator 'NOT LIKE' ignores empty record values.

If you want to include records with empty values as well then you need to apply query like below:

"short_descriptionNOT LIKESQL^ORshort_descriptionISEMPTY"

Your observation/expectation is correct but this is how it is.

[Sidney-]

Thanks Anil.

I already had the code amended to include that ^OR statement before posting the question but was silently hoping for a different answer hahah.

It is what it is.

Thanks for the time taken to answer.

Have a great day.

Best regards,

Sidney

[Dr Atul G- LNG]

Hi @Sidney- 

First of all I know about the ISEMPTY operator

ISempty is like searching for blank value