Add or remove query filters

Only want to show data matching certain conditions? This is where filters will come in handy. For filters in a visual mode query, you can filter by any available columns, even if they aren’t added to the “Columns” section.

Add a query filter

You won’t be able to add a filter until you first add a column. Once you’ve added a column, you’ll see the “Filters” section appear to the right of the “Columns” section.

To add a filter, click +Add Filter in the “Filters” section.

Select a column using the same process as described in Add a column.
After choosing a column, you’re prompted to choose a filter operator. The operator options vary depending on the aggregation type (for example, group or aggregate) and data type of your selected column.
After choosing the operator, you’ll need to provide values within the selected column to filter your data. Type in values manually or select the variables of your variable controls, if any, from the list. Values can be literal strings, variables, etc.

OR filters

By default, filter conditions in visual mode each have an AND between them, which means the data returned must match all the filter conditions. If you only need your results to match some filter conditions, you can change the operator to an OR by selecting the & button that connects the conditions. You can change it back to AND by selecting the button again.

But maybe you need more complex combinations of filter conditions with nested conditions and a mix of ANDs and ORs. To create a new subgroup of conditions, hover over the condition you’d like to include in the subgroup and select the conjunction that appears to the right of it. You’ll then see the option to add more conditions to your new subgroup.

For example, let’s say you wanted to set up the following filter conditions:

(Status = Signed AND Signature Date is null)
OR
(Status = Prepared AND Signature Date is not null)

This is how you’d do it in a visual mode query:

Creating the filter conditions described above the image

Reposition a query filter

Did you accidentally add a condition to the wrong subgroup? You can drag and drop the condition to the correct position (or use the undo feature to quickly undo it)!

Remove a query filter

To remove a filter, select the X within the filter’s block.