Search and filter
Last updated
Last updated
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.
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.
PowerTable offers both basic and advanced column-based filtering options, allowing you to filter specific data or a range of data based on your defined criteria.
Click on the Filter option to open column filters.
Using the basic filter option, you can select the required records directly. You can use the toggle button 'Require single selection' to select only one option at a time.
Use the advanced filtering option to filter based on specific criteria. Click on the 'Advanced' tab and specify the condition. The displayed conditions vary based on the data type of the column selected.
In the example below, we have filtered the products with prices greater than 100.
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 600'. All products within the price range of 100-600 are displayed.
