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.

1. Use the 'Search' option to start searching for specific records.

Search bar

1. Type the character/text in the search box. PowerTable starts narrowing down the matches as soon as you start typing.

Search for a record with text

1. You can also search for numeric values.

Search for numeric values

PowerTable searches across pages if the table spans over multiple pages.

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.

Open Filter pane

The filter pane opens, as below:

Filter pane with column filters

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.

Basic filter

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

Single selection

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.

Search for a filter criterion

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.

number filters

You can also use the slider or the text boxes to specify the range and filter the required values.

Slider to filter based on a range

In the example below, we have filtered the products with prices greater than $3000.

Records with prices>$3000

2.2.2. Text filter

The following criteria are available to filter text fields.

Text filters

PowerTable helps you with auto-suggestions even while typing in your criteria.

help suggestions

In the example below, we have filtered products whose color is either black or blue.

filter for text fields

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.

Nested filter

Clear a Filter

Click on this icon to clear a specific filter.

Clear filter

Clear all filters

To clear all applied filters at once, click the highlighted icon.

Clear all filters

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.

Top N filter

Enter the number of records to filter. Choose the field you want to filter by.

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