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

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

3. You can also search for numeric values.

{% hint style="info" %} PowerTable searches across pages if the table spans over multiple pages. {% endhint %} ## 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. {% hint style="info" %} Click the **Clear filter** icon beside the required filter to clear it or click **Reset All** to clear all the column filters applied. {% endhint %}