Filter or Search

Created by: Gunnar Steinn Magnússon

In this article, you are going to read about the filter or search function in the exMon table editor. The Table Editor has several powerful options to find and filter data. The main filtering options are:

  1. Search - Searches data in all columns
  2. Column Filters - Filter specific columns based on data existing in the columns
  3. Table Filters - Column filters for popular columns, chosen at design time.

Search

  1. Search bar
The search bar allows you to search for a specific term in all columns. Click Ctrl+F to start searching and enter the search term. When searching for multiple words, you can use quotes to search for them together.


 

Note: Searching data sets with millions of rows and many columns can be slow. You can use Column Filters and Auto Filter Row for a faster search.

Column Filters

Hover over a column header and click the Funnel icon to open a Column Filter. The filter shows all values currently in the data and allows you to quickly filter to specific values. Note that numeric and date/time columns allow you to filter based on ranges.


Auto Filter Row

Right-clicking on a column header and selecting Show Auto Filter Row displays powerful filtering options per column.


 

In the Auto Filter Row, you can enter search terms specific to each column. By default, the search term can be anywhere in the field.



 

Selecting the ABC icon allows you to change how the filtering is performed.




Table Filters

You can specifically configure table filters in the Table Designer. When there are columns with a defined filter, a Filters panel is displayed on the right.

  1. Selecting values in each column filters the data in the Table Editor. Selecting a filter value filters the values for other column filters. For example, selecting Black in the column Color removes all ProductSubcategory that does not have the colour, Black.
  2. The clear a column filter you can either deselect it or select the blue triangle.
  3. To minimize the Filters panel, click the pushpin.


Clear Filters

When you have selected any filter on the table, a Clear Filters button appears on the toolbar.

  1. Clicking that button clears all filters on the table.

 

Gunnar is the author of this solution article.