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