Filtering
There are a few methods for users to quickly find specific data.
Filters
Filters allow users fine-grained control over which rows are visible by only showing rows where certain conditions are met. Clicking the "Filters" button in the table toolbar will open the filter menu. To add a filter, simply select the column, an operator, and a value.
Example: [Title] [contains] [fixed] would populate only rows in which the value of the Title field included fixed
Here is the full list of available operators:
Operators for text values
- contains
- equals
- starts with
- ends with
- is empty
- is not empty
- is any of
Operators for date/time values
- =
- !=
- > (is before)
- >=
- < (is after)
- <=
- is empty
- is not empty
Additional filters can be added by clicking the "Add Filter" button in the bottom right corner of the filter menu. When using multiple filters, users have the option to specify a Link AND or OR. The first option will only populate rows that meet all of the filter conditions, whereas the second will populate rows that meet at least one of the active filter conditions.
Individual filters can be removed by clicking the X to the left of the unwanted filter. Clicking the "Clear All Filters" button in the lower left corner will return the filter menu to its default state and show all rows of the table.
When any filters are active, the filter icon in the table toolbar will display the number of active filters.
Active filters are saved across browser sessions.
Search
The search field can be found in the upper right corner of the table. For users in a hurry or with less specific filtering needs, it can quickly filter out rows where the search query does not appear in any column. Search functions the same as a filter on every column where the column value contains the search query, linked together with OR.