Query Operator Limitation (is one of)

poojasingh
Giga Contributor

I am using a client script and script include to send dynamic values to set filter in a slushbucket.

The filter applied on it something like "ID is one of" . Now here are more than 8000 IDs which should have been filtered, but it only shows 500 in the filter.

Is there a limitation on "is one of" logical operator? If yes, then is there any alternative way of doing this?

6 REPLIES 6

antin_s
ServiceNow Employee
ServiceNow Employee

Hi Pooja,



I dont think it is a query issue, but it is more of an issue with how many chars would be accepted for your HTTP Request. Please refer the below URL. According to me, more than 100 sys_ids being passed itself is an issue. I would suggest to change the filter not be based on sys_id and reply on some other meaningful conditions.



http - What is the maximum length of a URL in different browsers? - Stack Overflow



Hope this helps. Mark the answer as correct/helpful based on impact.



Thanks


Antin


bernyalvarado
Mega Sage

Does that make sense? I hope it helps!



Thanks,


Berny