On a Catalog Form, there is a Reference variable. But it gives poor search accuracy. What to do?

[AbdurRahmanSnow]

Good afternoon.
On a Catalog Form, there is a Reference type variable. But it gives poor search accuracy. What can be done for this?

Example, there is a choice option called Digital Marketing. To search this, we need to type left to right.
But if I type just 'Marketing', it does not come in the results.  How to resolve this issue?

[J Siva]

Hi @AbdurRahmanSnow 
You can use wild cards to search the options.
For ex: Instead of "Marketing" type "*Marketing".
Use asterisk (*) in front of the actual text.
It will give you all the dropdown/reference values that contain the word 'Marketing'.
Regards,
Siva

[Dr Atul G- LNG]

Hi @AbdurRahmanSnow 

If you're searching the way you are currently, the system treats it functionally—meaning it looks for records where "marketing" is the first word. If there's no exact match at the beginning, it won’t return results.

💡 To search within the entire value (i.e., "contains" search), use *marketing. This tells the system to look for any entry where the word marketing appears, regardless of its position.

https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/administer/search-admin...

[AbdurRahmanSnow · Accepted solution]

Got it. We need to create a new User Preference record in the User Preference table and set it to true, along with the table name. (Screenshot below)
Link: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0750081