EncodedQuery in Business Rule is not working

[Community Alums]

Hi - 

I am trying to restrict records based on model category and location. Here is the encoded query that works in filter query but when I try to apply this in Business Rule before query it doesn't work. It returns all records. This has to do something with using 'NQ' and it seems like it provides inconsistent returns. I tried changing it to "OR" but that doesn't work either. Please help. 

Spoiler

model_categoryNOT LIKEServer^locationANYTHING^NQmodel_categoryLIKEServer^location!=1f895fd8db2ff6004ad038f0ad9619b0

[SanjivMeher]

If you could post the script, I can try to modify it

[Arav]

Hi,

This could be due to a known platform behavior (not issue). Please see the article below for more details.

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

Thanks,

Arav

[Community Alums]

Thanks! any suggestion or workaround for this?

[Arav · Accepted solution]

You may want to get the current query and then add the new conditions to it.

var enc = current.getEncodedQuery();

While adding, please ensure that the conditions are applied appropriately as otherwise it will end up returning all rows.

Thanks,

Arav

[Arav]

@Community Alums checking back to see if you were able to apply the suggestion provided