- 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 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:11 AM
Hi Mike_R
I have a list of users with the "user_name" field that contains a string with commas,
there are around 400 records and when trying to apply the filter "is one of"
it does not return a correct result because of those commas.
Any idea how to find them?
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 07:19 AM
is it feasible for you to use another field such as email?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 07:33 AM
No, I can't use another field.