Items in data lists can be filtered. To filter items, click in the field located above a data list column to select it, and enter the text you want to use to filter the items in the list.
If you want to use different operators to filter the items in the list, select the filter icon next to the field.
The following filter operators are available for most columns:
Filter Operator |
Description |
---|---|
Starts with |
Values that start with the value specified in the field will be displayed. |
Ends with |
Values that end with the value specified in the field will be displayed. |
Contains |
Values that contain the value specified in the field will be displayed. |
Does not contain |
Values that do not contain the value specified in the field will be displayed. |
Equals |
Values are that are equal to the value specified in the field will be displayed. |
Not equals |
Values that are not equal to the value specified in the field will be displayed. |
If the column displays a numeric or currency data type, the following filter operators are available:
Filter Operator |
Description |
---|---|
Equals |
Values are that are equal to the value specified in the field will be displayed. |
Not equals |
Values that are not equal to the value specified in the field will be displayed. |
Greater than |
Values that are greater than the value specified in the field will be displayed. |
Less than |
Values that are less than the value specified in the field will be displayed. |
Greater than or equal to |
Values are that are greater than or equal to the value specified in the field will be displayed. |
Less than or equal to |
Values that are less than or equal to the value specified in the field will be displayed. |
If the column displays a date data type, the following filter operators are available:
Filter Operator |
Description |
---|---|
On |
Dates that are on the date specified in the field will be displayed. |
After |
Dates that are after the date specified in the field will be displayed. |
Before |
Dates that are before the date specified in the field will be displayed. |
Today |
The current date will be displayed. |
Yesterday |
The previous day's date will be displayed. |
This month |
Any dates in the current month will be displayed. |
Last month |
Any dates in the previous month will be displayed. |
Next month |
Any dates in the next month will be displayed. |
This year |
Any dates in the current year will be displayed. |
Last year |
Any dates in the last year will be displayed. |
Next year |
Any dates in the next year will be displayed. |