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.
Note: In UI11, the Go to and Search options are displayed side-by-side in the header.
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.
    In UI11, you can press the Enter key or click the search icon ().

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 search-term.

Searching without wildcard characters

If you enter text in the search box without using a wildcard, the search returns results 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 with the name number or u_number is treated as a numeric field. The field label has no effect on search results.

Setting default search behavior

Administrators can add a property to perform a default contains search instead of a greater than search. To make this change, Add the property glide.ui.goto_use_contains and set the property Value to true.