Fuzzy search in Location / Department fields

[Haico Jolink1]

Hi all,

This is my very first post. We are currently struggling with the lack of 'fuzzy search' in specifically the Location and Department fields. I work for an Dutch company within healthcare and we have several locations at which an number of different teams work. However the names of the teams vary quite a bit. For example: an team can be called 'Zorgteam de Kolibri'. My colleagues from that team don't know their full team name is written like that. They online know their name (in this example Kolibri).

Our wish is that the colleagues can search by for example ''Kol', without having to search with wildcard. We tried explaining the wildcard method, but unfortunately our colleagues struggle with that.

Thanks in advance for your tips and advice!

[erik_brostrom]

Take a look at this article and see if it helps:
https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/field-administrati...

[Allen Andreas · Accepted solution]

Hi,

If you navigate to the dictionary for this field (if it's on a form) or if it's a catalog/record producer variable go to it's settings and look for the attributes field (you may need to click "Advanced view" in the related links section on bottom-left)...once you're in the attributes add something like this:

ref_ac_columns_search=true,ref_ac_order_by=name,ref_ac_display_value=false,ref_ac_columns=name;title,ref_auto_completer=AJAXTableCompleter,edge_encryption_enabled=true

Replace name and title with any other additional columns for the locations/departments that you think could be relevant to search upon (you could just go with name at first and see if you like that), this allows users to type stuff like kol...and see all results that have "kol" in it...very useful.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[sayali udgave]

Hi

You have to put below into your catalogs item attrive advance view

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=Location,ref_ac_order_by=

Location

Mark helpful if it solve your problem
Thanks