Searching and Filtering
Searching and filtering options are shown within each column under the column header.
Searching and Filtering Options
Searching Data
To search for Data within a column:
- Click into the Search Box
- Type your search term
Typing into the Search Box
Results will automatically update. The number of search results is displayed in the bottom left-hand corner alongside the total number of Filters you have set.
Search Results and Total Filters Set
To clear that search:
- Click into the Search Box
- Delete the search term
Deleting the Search Term
Filtering Data
To set a Filter on Data within a column:
- Click the Filter icon
The Filter Icon
Select the Data you want to filter on.
Selecting the Data
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 are filtered.
Search Box Displays Filtered Terms
The number of filter results is displayed in the bottom left-hand corner. Along with a number of filters you have set.
Filter Results and Filters Set
To clear a filter in this specific column:
- Click the filter icon in that column.
- Then click select all.
Ticking SELECT ALL to Clear Filters
Sorting Data
To sort data in any column click on the column title. Sort direction is indicated by the arrow next to the column title.
Clicking on the Column Title
Click the column title for a second time to change the sort order. The sort order updates and the arrow changes direction.
Click a Second Time and the Arrow Changes Direction
Click a third time to remove this sort order and return to the default order.
Click a Third Time to Return to Default Order
Default
Search filters and sorting will be stored for when you return to this page on the same device.
To return the table to the default view:
- Click the view menu.
- Select reset view.
Click Reset View to Return the Table to the Default View
The default view is restored