"Is one of" filter option replacing spaces with commas

Sue Frost
Giga Guru

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:

search on user ID.png

But if I search on the Name field, I don't get any results:

search on name.png

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!

1 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.


View solution in original post

7 REPLIES 7

Chuck Tomasi
Tera Patron

Hi Sue,



I suspect it is something with your system configuration, although I don't know what (yet). I am unable to confirm this on my Istanbul instance.



find_real_file.png


I would agree.



The one thing I missed in my "I've confirmed list" ... this isn't happening in an OOTB personal instance.


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.


Will do - thanks for the quick reply.