How to Configure Filters
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.
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 icon in the Details pane.
You can also temporary disable a filter in a query without removing it. For this click the icon 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.
When you add several filters to a query, they can be united into groups and subgroups. Each 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 check Filter Groups.
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. Relative filters are supported for the fields with datetime data only.
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 Filters 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.
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:
- In the Details pane, click List.
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 until all the required values are loaded.
If there are too many values in the list, you can use the Type to filter box to quickly find the necessary values. Start typing the value, and only values, containing the entered string, will be displayed.
- 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.
Relative filters allow quickly filtering records with datetime values within a specified period. To configure a relative filter, perform the following steps:
- In the Details pane, click Relative.
- 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.
- Select the necessary period in the bottom part of the Details pane.