Search and Filter
Searching and filtering options are shown within each column under the column header.
Search box and filter icon.
Searching
To search for data within a column click into the search box.
Type your search term.
Results will automatically update.
Data listed.
The number of search results is displayed in the bottom left-hand corner alongside the total number of filters you have set
Results displayed with filters set.
To clear that search click into the search box and delete the search term.
Clearing the search term.
Filters
To set a filter on data within a column click the filter icon.
Filter icon.
Select the data you want to filter on.
Selecting the data for filtering.
To hide the filter box click the filter icon at the top or click outside of the filter box.
Hiding the filter box.
The search box will now display the number of terms you filtered on and list out which ones.
Search box displays terms.
The number of filter results is displayed in the bottom left-hand corner Along with a number of filters you have set.
Number of results and filters set.
To clear a filter in this specific column click the filter icon in that column. Then click select all.
Clearing a filter.
Date Filtering
To filter by date range. Click onto the filter icon in the column you wish to filter.
Date range filter icon.
Various filtering options can be selected from the dropdown menu including specific date, range between two dates, and before or after a specific date.
Filter options dropdown.
In the example a range has been selected with a to and from date selected. Results display all dates within these two dates.
You can also pick AND OR to further filter your selection.
AND, OR.
Remove the filters by clicking on REMOVE FILTERS.
Remove filters.
Column Sorting
To sort data in any column click on the column title.
Sort direction is indicated by the arrow next to the column title.
Sorting.
Click the column title for a second time to change the sort order. The sort order updates and the arrow changes direction.
Reversing the column order.
Click a third time to remove this sort order and return to the default order.
Setting default order.
Search filters and sorting will be stored for when you return to this page on the same device.