Configure the default search behavior

The default search behavior in a list is to search for values that are greater than or equal to the value you enter. Administrators can add a property to change the search behavior to use a contains search by default, instead of a greater than search.

About this task

If you enter text in the search box without using a wildcard, the search is performed for values greater than or equal to the value you enter. For text data-type-fields, this means that the search first sorts the records on the selected field, then finds the first record that starts with the text and all following records. For numeric data-type-fields, this means that the search finds all records where the number field ends with the entered number.
Note: The system treats some string fields that contain record numbers as numeric fields. Any field named number or u_number is treated as a numeric field.

Role required: admin

Procedure

  1. Navigate to the list of system properties by typing sys_properties.list into the navigation filter.
  2. Add the following property. For more information on adding a property, see Add a property.
    Table 1. Default search behavior property
    Field Value
    Name glide.ui.goto_use_contains
    Type true | false
    Value true
  3. Click Submit.