"Is one of" filter option replacing spaces with commas

[Sue Frost]

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!

[Sue Frost · Accepted solution]

ServiceNow advises this is a known issue - PRB710112 - related to List v3 and is expected to be fixed in Jakarta.

They offered three workarounds:

1. Disable List v3 entirely
2. Disable List v3 for the impacted table.
3. 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.

[Chuck Tomasi]

Thanks for the update. I wonder why it's not an issue on my Istanbul instance. Strange

[changfa]

I have the same issue for this filter. it did not work for string with a space inside. it cut off the string from the space. it is for istanbul version. the issue is on groups.