Drop-Down Lists - Unity Client - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - Premier - external - Standard - Essential - Premier - Standard - Essential

In conjunction with column filter operators, column filter drop-down lists are used to select or enter a value that defines how to apply a filter to a data list.

To select an option from a column's drop-down list, click the drop-down arrow:

To enter a value in the drop-down list, click to the left of the drop-down arrow and enter the value. The data list is filtered as you type.

The following options are available for selection from all drop-down lists:

Each column's drop-down list also contains all the unique values in the data list for that column. For example, in a Document Search Results list, the drop-down list for the Type column lists the Document Types of the documents found during the search:

In addition to unique values in the data list, drop-down lists may contain comparative or general options to filter by non-specific values. For example, the drop-down list of columns containing numerical or date values may include comparative options, such as Above Average and Bottom 10. When a data list is filtered by these options, the only list items displayed are those whose value in the filtered column meets the criteria when compared with the values in that column for all items in the data list, regardless of filtering applied to other columns.

For columns containing date values, the drop-down list filter options may also contain relative and general options. For example, options such as Yesterday and Next Month are relative to the current date. Options such as Quarter 1 and January are not relative to the current date and will display list items that meet the criteria in any year.

All filtering applied to a data list column can be cleared by clicking the following button: