Search by approximate name in a reference variable

[Sancley]

Hello everybody,

We have a field called Configuration item that references our CMDB,

It does a search for the exact name, but I would like it to do a search with approximate,

The same already occurs when I insert the (*)

I appreciate any help.

[ryan_pope]

The image links look to be broken, but if I understand the ask, it's to be able to use a reference field, where you type in and the search pulls back results based on a "contains" search rather than a "start with" search. If that's the case, here's some instructions on how to go about doing that: 

https://community.servicenow.com/community?id=community_question&sys_id=d90ad0171b3a045cd01143f6fe4b...

1. Disable the glide.ui.ref_ac.startswith system property . See Improving Auto-Complete Queries.
2. Navigate to User Administration > User Preferences.
3. Select the preference "'<referenced table>.autocomplete.contains"'.
4. Set the value field to true.
5. Log out and log back in to immediately display the updated search.

[Ankur Bawiskar]

Hi,

what does approximate mean?

images are broken

Regards
Ankur

[Sancley]

Hi Bawiskar, thk!

Sorry about that.

[Ankur Bawiskar]

Hi,

did you give this in the field attributes i.e. ref_ac_columns

ref_auto_completer=AJAXTableCompleter, ref_ac_columns_search=true, ref_ac_columns=u_fieldName

Auto-complete for reference fields

You can use wildcard search using asterisk

Regards
Ankur