Symptoms

For a reference field on a form, searching for a value and clicking on reference lookup, the search takes 'Starts With' instead of 'Contains'.

(Eg : For assignment group field on incident record, on entering fo, two valid results are shown. Clicking on reference lookup shows Name starts with 'fo' and not Name contains 'fo'). 

Release

Any supported release

Cause

The system property 'glide.ui.goto_use_contains' controls the search in the list view and not reference lookup.

Resolution

A system level user preference with the format <table_name>.autocomplete.contains with value true has to be created for contains search to work on reference fields.

For assignment group field, User Preference with below details has to be created:

Name :sys_user_group.autocomplete.contains

Type : true|false

Value : true

System : true

Once the user preference is created, make sure to clear the instance cache (by doing cache.do) and login back to the instance.