Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to search with the filter "is one of" character strings that contain commas

Victor Mesa
Tera Contributor

I want to search the list of users in sys_user for records that have values ​​with a comma character in the user_name field, but the "is one of" filter does not allow me to do that search. Any idea how to find them?

 

Thanks.

1 ACCEPTED SOLUTION

Mike_R
Kilo Patron
Kilo Patron

Straight from ServiceNow's documentation

Note: Do not use the [is one of] operator on fields that contain commas, as the query does not return the expected set of records. Instead, create a filter using multiple [or] statements.

https://docs.servicenow.com/bundle/sandiego-platform-user-interface/page/use/using-lists/task/t_Filt...

 

What's the use case /requirement exactly? Maybe I can help come up with another query to yield the same result.

 

View solution in original post

6 REPLIES 6

I mean SN's documentation says it's not possible so you might be out of luck.

https://docs.servicenow.com/bundle/sandiego-platform-user-interface/page/use/using-lists/task/t_Filt...

 

I would open a case with them to see if they have any workarounds. If I think of another option I will post it here

you can try a keyword search with an OR operator | between each User ID. This worked for me

Mike_R_0-1666104220984.png