- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 12:56 AM
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.
Solved! Go to Solution.
- Labels:
-
Service Level Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 06:34 AM
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.
What's the use case /requirement exactly? Maybe I can help come up with another query to yield the same result.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 07:40 AM
I mean SN's documentation says it's not possible so you might be out of luck.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 07:43 AM
you can try a keyword search with an OR operator | between each User ID. This worked for me