How to Configure Filters

ExpandedToggleIcon        Adding, Removing, and Disabling Filters

To filter data by some column, drag this column from the Connection Object List to the Filters pane. Then click it in the Filters pane and configure the filter in the Details pane on the right side of the page as described below.

note Note

Skyvia Query filters are type-specific, the available filters depend on the data type of the column. See the list of Supported Filters for each of the column types.

To remove a filter, click it in the Filters pane and then press the Delete key or click the query-icon-delete button in the Details pane.

You can also temporary disable a filter in a query without removing it. For this click the query-icon-disable button in the Details pane header. This will remove the filter from the generated SQL statement, but keep it in the Query Builder so that you will be able to re-enable it. To enable it back, select it on the Result Fields pane and click the same button in the Details pane header again.

note Note

When you add several filters to a query, they can be united into groups and subgroups. A group consists of several filters and/or subgroups, united with a logical operator (AND or OR). For the information about how to create and configure filter groups see Filter Groups.

 

ExpandedToggleIconConfiguring Filters

Skyvia supports three kinds of filters: value filters, list filters and relative filters. Value filters are supported for all field types. List filters are supported for fields with string data only, and Relative filters are supported only for the fields with datetime data only.

Value Filters

Value filters simply compare the field value with the specified one using different comparison operators or check whether the field value is NULL.

For value filters, the configuration is pretty straightforward: on the Details pane, in the Filter list select the necessary filter. Then, if the selected filter requires a value to compare the field with (like equal to or between), specify this value or values.

query-between-filter

List Filters

List filters allow you to quickly select one or more values from a list of the distinct values, available in the data source for this field, and get or exclude records with selected values from the list. They are especially useful when a field in the data source can have one of a fixed set of values. To configure a list filter perform the following steps:

1.In the Details pane click List.
2.Select check boxes for the required values in the list. If you don't see all the required values, click the Load more link in the end of the list till all the required values are loaded.
 
If there are too many values in the list, you can use the Search box to quickly find the necessary values. Start typing the value, and only values, containing the entered string will be displayed.
3.If you want to filter out records with selected values, click is in list and select is not in list. If you want to retrieve the records with such values, omit this step.

query-list-filter

Relative Filters

Relative filters allow quickly filtering records with datetime values within a specified period. To configure a relative filter, perform the following steps:

1.In the Details pane click Relative.
2.If you want to filter out values within the period, click is in and select is not in from the list. If you want to retrieve the records with values within this period, omit this step.
3.Select the necessary period in the bottom part of the Details pane.

query-filter-relative