Search a list

You can search a list to find information quickly. The list title bar includes options for searching the list. Administrators can enable text searches for any list.

Before you begin

Role required: none

About this task

There are two options for searching the list: for a string in a selected field, or for a text string found in any field. In List v2, these options are labeled Go to and Search. In List v3, the search fields appear with no label.

  • The Go to option sorts the list by the selected field and returns records where the field value is equal to or greater than the search term. For the Number field, which is a string type field, it finds the records that have a number ending with the number that you enter. For example, searching a list of incidents by selecting Number and entering 4 shows records with numbers like INC0000004 and INC0000014.
  • The Search option appears when you select for text. It returns records that contain the search term in any field in the list table. If you added a related list condition, the search does not include records in the related table.
Each option in a choice list is defined with a column label and a value. For example, the incident Statefield contains several options, such as New and Closed. These labels are column labels, and each one has an underlying value. For incidents, the default value for New is 1 and the default value for Closed is 7. You can search a column for either the column label or the value with the following results.
  • Enter the column label to list matching records, for example, all incident records in the New state.
  • Enter the value to find records that have a state greater than or equal to (=>) the specified value. For example, enter 6 to list incident records in the Resolved and Closed states.

Procedure

  1. Navigate to a list of records.
  2. If necessary, personalize the list to add the desired fields.
  3. Select a field or select for text.
    Go to
  4. Enter the search text. Use wildcards to further refine list searches.
  5. Press the Enter key to execute the search.

Search by one or more columns in a list

In addition to searching by field or for text, you can search by one or more individual columns in a UI16 or UI15 list.

Before you begin

Role required: none

About this task

Figure 1. Column search (List v2)
Column search

This search supports queries that include AND, but does not support OR. You cannot search in a column that uses the List field type, for example, watch lists.

Procedure

  1. Click the search icon Search icon to expand the column headers and add a search field to each column.
  2. To search a single column, enter the search text in the desired column search field and press the Enter key.
    Use wildcards to further refine column searches. For example, use the * to define a contains search.
  3. To search multiple columns, perform one of the following actions.
    • Enter the search text in each of the desired column search fields and press the Enter key.
    • Search an individual column and then search additional columns based on the results of the first search.

Result

The search returns records that match the search term.

What to do next

To clear a column search, complete one of the following actions.

  • Delete the text in the search field for the desired column and press the Enter key. This returns results for any remaining column search criteria.
  • Delete the text in all the column search fields to return all records in the list.

Available list search wildcards

The platform supports several wildcard characters to expand and refine search results.

Table 1. Available list search wildcards
Wildcard Description

*search-term

%searchterm%

Search for values that contain search-term.
%search-term Search for values that end with search-term.
search-term% Search for values that start with search-term.
=search-term Search for values that equal search-term.
!*searchterm Search for values that do not contain search-term.
!%searchterm Search for values that do not end with search-term.
!=searchterm Search for values that do not equal searchterm.

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 2. Default search behavior property
    Field Value
    Name glide.ui.goto_use_contains
    Type true | false
    Value true
  3. Click Submit.