Search and filter
We will now explore the various options in EDITable for searching and filtering data. These options allow you to analyze data in chunks, especially when dealing with a large volume of data.
1. Search
The Search option allows you to quickly locate specific records in your table by entering characters, words, numbers, or phrases. EDITable displays all records containing the entered character, number, or text.
In the 'Home' tab of the toolbar, click on the 'Search' icon.
Type the character/text in the search box. EDITable starts narrowing down the matches as soon as you start typing. Navigate through the results using the up and down arrows.
You can also search for numeric values as shown in the below image.
EDITable searches across pages if the table spans over multiple pages.
2. Filter
EDITable provides nested AND/OR filtering options to filter a range of data based on the criteria you define.
2.1. Nested and grouped filters
Nested filters
In the 'Home' tab of the toolbar, click on the 'Filter' icon.
Click Add Filter. Based on the column selected, different conditions are provided. You can select a condition as shown below.
In the example below, the data has been filtered based on the job title.
You can add multiple filters using the Add Filter option and apply nested AND/OR conditions. In the example below, we have added one more condition to filter only those with salaries greater than 180000 for the given job title. Both conditions have been combined using the AND operator.
Grouped filters
You can also organize multiple filters into filter groups. Click Advanced.
Click Add group to add another group. In the below example, we have added four conditions nested using AND/OR and using two filter groups. The filtered table is also shown.
You can delete the individual filters by clicking on the 'Delete' icon available next to the condition.
The Persist filters option ensures the filters are retained when switching between pages in the visual.
Click on Reset All to reset all the filters.
2.2. Column-level filter
EDITable provides both basic and advanced column-based filtering options to filter specific data or a range of data based on the criteria you define.
When you mouse over any column, a three-dot menu appears as highlighted. Click on it and then select the 'Filter' icon.
You can do basic filtering by selecting the required data from the drop-down list.
You can also apply advanced filtering based on specific criteria. Click on the 'Advanced filter' icon to specify the condition. The displayed conditions vary based on the column selected. In the example below, we filtered the employees whose salaries exceeded 100k.
You can add nested AND/OR filters by clicking the Add rule option. In the below example, we have added one more condition - 'less than 200k'. All employees whose salaries range between 100k and 200k are displayed.
Click Clear filter beside the required filter to clear it or click Clear All to clear all the column filters applied.
Last updated