Enable contains auto-complete searches

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

Before you begin

Role required: admin

Procedure

  1. Disable the glide.ui.ref_ac.startswith system property.
    For more information, see Improve auto-complete queries.
    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 auto-complete query method for all users regardless of preferences.
  2. Navigate to User Administration > User Preferences.
  3. Select the preference "'<referenced table>.autocomplete.contains"'.
  4. Set the value field to true.
    Autocomplete user preference set to true
  5. Click Update.

What to do next

Log out and log back in to display the updated search.