How can I change the default search on a list collector to search on 'contains'?

nortonxnorris · ‎03-06-2015

I have a list collector of software's. I would like the search pull the values based on 'contains' rather than 'starts with'.

Where do i make this change?

Jon23 · ‎03-06-2015

You should be able to use this: Auto-Complete for Reference Fields - ServiceNow Wiki

10 Contains Auto-Complete Search

By default, the reference auto-complete uses a starts with search. A user preference can be created to implement a contains search.

To use the contains search:

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

Note: Setting the glide.ui.ref_ac.startswith system property to true overrides any existing "autocomplete.contains" settings in both user and system level preferences. This property changes the autocomplete query method for all users regardless of preferences.

View solution in original post

Bill Ye Zhang · ‎10-21-2024

Thank you! Great catch. I was bit confused with "sys_user.autocomplete.contains" until I saw your comment. This has resolved my issue. Thanks a billion!