Improve auto-complete queries

By default, all reference fields use a starts with query to search for matching text in the reference table. This prevents auto-complete from executing inefficient contains queries every time a user searches a reference field. You can require all reference fields to use a starts with query.

Before you begin

Role required: admin

About this task

The following example illustrates a contains query. Note that the letter "d" appears anywhere in the user's first or last name.
Auto-complete contains query

This procedure describes how to change the glide.ui.ref_ac.startswith system property to always use a starts with query.

Procedure

  1. In the navigation filter, enter sys_properties.list and press the Enter key.
  2. Select the glide.ui.ref_ac.startswith property.
    To search for the property, enter *startswith in the Go to search filter for the Name column.
  3. In the Value field, replace false with true.
    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.
  4. Click Update.
  5. Test the change by opening a record with a reference field and entering a character in it, as illustrated in the example below.
    Auto-complete starts with query