Search and filter
We will now explore the various options in PowerTable 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. PowerTable displays all records containing the entered character, number, or text.
Use the 'Search' option to start searching for specific records.
Type the character/text in the search box. PowerTable starts narrowing down the matches as soon as you start typing.
You can also search for numeric values.
2. Filter
PowerTable offers both basic and advanced column-based filtering options in a separate Filter pane, allowing you to filter specific data or a range of data based on your defined criteria.
Click on the arrows to expand the Filter pane, which includes various column filters.
The filter pane opens, as below:
2.1. Basic Filter
Using the basic filter option, you can select specific records directly. You can select the 'Require single selection' box to enable selecting only one option at a time.
'Require single selection' is selected:
Since single selection is enabled in the example below, you can choose only one option to filter the products at a time.
Searching for a filter criteria
You can use the search box to look for specific criteria to filter by, especially when there are a lot of options.
2.2. Advanced filters
Use the advanced filtering option to filter based on specific criteria. Click the 'Advanced' tab and specify the condition. The displayed conditions vary based on the data type of the column selected.
You can also filter Top N records based on a numeric field.
2.2.1. Number filter
To filter 'Number' type fields, you can use any of the below criteria highlighted in the image.
You can also use the slider or the text boxes to specify the range and filter the required values.
In the example below, we have filtered the products with prices greater than $3000.
2.2.2. Text filter
The following criteria are available to filter text fields.
PowerTable helps you with auto-suggestions even while typing in your criteria.
In the example below, we have filtered products whose color is either black or blue.
2.2.3. Nested filters
Add nested filters by applying multiple filter criteria simultaneously.
In the example below, we have filtered products that are black in color and have a price greater than 3000.
Clear a Filter
Click on this icon to clear a specific filter.
Clear all filters
To clear all applied filters at once, click the highlighted icon.
2.3. Top N filter
The 'Top N' filter option allows you to select the top 'n' records based on any numeric field. Click on the three dots on any field and choose Top N.
Enter the number of records to filter. Choose the field you want to filter by.
Last updated