How to change search type of reference field on catalog from "Starts With" to "Contains"

[vaibhavdesai]

Hello All,

Is there a way to change search behavior of catalog variable(lookup/reference)?
Default search always uses "Stars With" query, I want to change it to "Contains". And is it possible to display records based on search from more than 1 column.

Thanks in advance!

Regards,

Vaibhav

[karthiknagaramu]

Hi,

Which can be achieved using a system property. Please check the below link.

Auto-Complete for Reference Fields - ServiceNow Wiki

Regards,

KN

[vaibhavdesai]

Hello Karthik Nagaramu,

Can you please point me to exact content point in the wiki link you have shared. I am only able to see about "Auto complete" feature.

Regards,
Vaibhav Desai

[karthiknagaramu · Accepted solution]

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.

[vaibhavdesai]

Changing this value will effect on global level right? I want to change this only for one variable. Is there anyway of doing it.