Skip to main content

Creating a simple Filter

To quickly view and filter data without re-running a Query, use a post-query Filter. To access them, open the Query and find the Filter Bar with the + icon in the top-left corner.

A Query results page with the Filter Bar highlighted
The Filter Bar.

Adding a Filter​

A Query can have two main types of Filter: general Filters and field-specific Filters. Creating a Filter produces a green capsule called a Filter Chip in the Filter Bar.

General Filters​

To create a general Filter, place the cursor in the new Filter field next to the + icon and begin typing. When the search term is complete, press Enter. The entire string becomes a Filter Chip, and the Query displays only rows that contain the search term.

  • Entering 123 displays only rows that contain the characters 123 somewhere, separated by a space or punctuation. An address of "123 Main Street" meets the criteria, while "Salem, NC 27123" does not, because the 123 is part of 27123. Filtering by Castro matches "Av. Inês de Castro, 414". Filtering by 634 does not match "05634-030".
  • Informer ignores duplicate spaces in 123 Main Street and treats and displays it as "123 Main Street" after you press Enter.

Field-specific Filters​

To restrict criteria values to a specific Field, click the + at the far left of the Filter Bar to display a dropdown of the Fields available for filtering, or type a known Field name into the Filter Bar.

The add-filter plus icon next to the Filter placeholder
The Filter Bar + icon.

To begin filtering, select the Field to filter by, select Include or Exclude, then choose a type of filter in the submenu.

The Filter criteria options with Include/Exclude and the filter-type submenu
Filter criteria options.

Continue adding Filter Chips with either method. After each Filter, the Query narrows to information that matches all of the values. Selecting OR or NOT changes the behavior, described below.

Filtering using AND, OR, and NOT​

The option to switch between All (logical AND), Any (logical OR), and None (logical NOT) is available when there are at least two Filters within the same Filter Chip.

  • Match all: rows must satisfy all of the Filter Chip's criteria. The configuration screen shows the options in green. For example, rows must contain Employee First Name "Janet," Ship State "NM," and Product Name "Gnocchi."
  • Match any: rows satisfy any of the criteria. The configuration screen shows the options in orange. For example, rows must contain Employee First Name "Janet," Ship State "NM," or Product Name "Gnocchi."
  • Match none: results contain no row satisfied by the Filter Chips. The configuration screen shows the options in dark orange. For example, rows cannot contain Employee First Name "Janet," Ship State "NM," or Product Name "Gnocchi."
A Filter Chip configuration set to Match any with three collapsed Field filters
Match any.

Removing a Filter​

To remove a Filter, click the X on the right side of its Filter Chip. To disable a Filter without removing it, select the Chip and click the switch in the bottom-left corner of the Filter panel. A disabled Chip turns gray.

A Filter panel with the disable switch
Disabling a Filter.
A grayed-out, disabled Filter Chip
A disabled Filter.
Also available through the REST API
Everything on this page is built on Informer's public REST API, the same one the product uses, so your scripts and integrations can do it too. Developer reference: Queries.