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.
To remove a filter, click it in the Filters pane and then press the Delete key or click the button in the Details pane.
You can also temporary disable a filter in a query without removing it. For this click the 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.
Skyvia supports four kinds of filters: value filters, parameter filters, list filters and relative filters. Value and parameter 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 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.
Parameter filters are very similar to value filters. The difference is that they compare a field not with a constant value but with a parameter. A parameter is a variable that you can set to a value without modifying the query. See Using Parameters for more information about using parameters in queries and setting parameter values.
To configure a parameter filter perform the following steps:
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:
Relative filters allow quickly filtering records with datetime values within a specified period. To configure a relative filter, perform the following steps: