- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2017 06:44 AM
With our recent upgrade from Geneva to Istanbul, we discovered that the "IS ONE OF" filter option is behaving differently.
I am no longer able to use the "is one of" option when searching for a string that contains spaces:
Here's a search on two existing users by userID. Clearly, the user records exist:
But if I search on the Name field, I don't get any results:
If you look closely, you can see that the actual search string looks like this:
INsue,frost,rob,kling
I've confirmed that:
- the custom calculation that creates the Name field isn't the issue
- I see the same issues when searching for other strings in other lists
- wildcard characters don't help
- surrounding the search string with quotes doesn't help
Has anyone else run across this issue and if so, how did you solve it?
Is this a known issue in Helsinki or Istanbul?
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-27-2017 06:26 AM
ServiceNow advises this is a known issue - PRB710112 - related to List v3 and is expected to be fixed in Jakarta.
They offered three workarounds:
- Disable List v3 entirely
- Disable List v3 for the impacted table.
- Enter each name separately ... Name = Sue Frost OR Name = Rob Kling OR Name = Frodo Baggins, etc.
I've decided to disable List v3 on the impacted table (sys_user) only. Very few of our users look at that table on a regular basis, with the exception of the group that reported the issue and we admins.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2017 06:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2017 07:03 AM
I would agree.
The one thing I missed in my "I've confirmed list" ... this isn't happening in an OOTB personal instance.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2017 07:44 AM
I've gone through the OOB system properties and don't see anything suspicious. It might be time to turn it over to customer support. Something on that instance is definitely different than OOB. I'll be interested to hear what they say.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2017 07:51 AM
Will do - thanks for the quick reply.