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:
The Custom Filter Selection dialog box is opened, and a custom filter can be created.
For more information, see Custom Filter Selection.
Blank values for the column are displayed.
Any non-blank values for the column are displayed.
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.
When comparative filter options are selected for columns with date values, Top refers to the most recent date and Bottom refers to the oldest date.
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: