EncodedQuery in Business Rule is not working

Community Alums · ‎12-22-2022

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

Arav · ‎12-22-2022

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

View solution in original post

jaheerhattiwale · ‎12-29-2022

@Community Alums Hope you are adding query like below after the extraQuery line

current.addEncodedQuery(extraQuery);

Please mark as correct answer if this solves your issue.

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023