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.

1. In the 'Home' tab of the toolbar, click on the 'Search' icon.

'Search' option

1. 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.

Search record using text

1. You can also search for numeric values as shown in the below image.

Search for numeric values

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

1. In the 'Home' tab of the toolbar, click on the 'Filter' icon.

'Filter' option

1. Click Add Filter. Based on the column selected, different conditions are provided. You can select a condition as shown below.

Add filter

1. In the example below, the data has been filtered based on the job title.

Filter results

1. 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.

Nested filter

Grouped filters

1. You can also organize multiple filters into filter groups. Click Advanced.

Advanced filter

1. 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.

Group filters

1. You can delete the individual filters by clicking on the 'Delete' icon available next to the condition.

2. The Persist filters option ensures the filters are retained when switching between pages in the visual.

3. Click on Reset All to reset all the filters.

Delete, Reset, Persist 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.

1. When you mouse over any column, a three-dot menu appears as highlighted. Click on it and then select the 'Filter' icon.

Column filter

1. You can do basic filtering by selecting the required data from the drop-down list.

Basic column filter.

1. 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.

Advanced filter

1. 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.

Nested column filter

Click Clear filter beside the required filter to clear it or click Clear All to clear all the column filters applied.