Reference field to search on 'contains'

[ebaileyybs]

I have created a reference field on the change form which relates to the project table.

I would the search on this field to be a contains search rather than starts with.

Can anyone help me achieve this please?

[marcguy]

your users can do this themselves by just typing * at the front of the search.

If you want to change this for everyone, be warned this can cause degradation very large tables in your reference field because imagine doing contains on 'a' that's why I prefer to keep the normal but allow users to use * for CONTAINS

create a global user preference:

Auto-Complete for Reference Fields - ServiceNow Wiki

[nortonxnorris]

Introduction to Searching - ServiceNow Wiki

Administrators can add a property to perform a default contains search instead of a greater than search. To make this change, add the property glide.ui.goto_use_contains (it is not available by default) and set the property value to true.

[peterraeves]

So if I understood that correctly, I need to create a user preference for every single table...? There must be a better way to do this, no?

[Michael Fry1]

mguy is right. You would need to create for each table, as there isn't a universal property to change. However, most just create for the table that you want to search using contains, not every table.