Configure a filter in data sources
In the Setup and Sync Tool at Data Model > Data Sources, configure Data Sources. Optionally, you can filter out irrelevant data from a data source. You can set up filters on the Filter tab of a data source.
Configuration
Column
|
Specify the column in the external data source to which you want to apply the filter.
|
Operator
|
Specify how to compare values. See below for an overview.
|
Value
|
Specify the value on which you want to filter. Expressions in a filter are evaluated based on a text comparison with the data in the external data source.
|
OR and arrow buttons
|
If you specify multiple expressions, ALL expressions apply by default. Click OR and the arrows to create groups of expressions.
|
List of available operators
>
|
Is greater than
|
>=
|
Is greater than or equals
|
<
|
Is less than
|
<=
|
Is less than or equals
|
=
|
Equals
|
<>
|
Is different than
|
LIKE
|
Is like. This operator matches a given pattern. Use this operator if the value in the conditional expression contains a wildcard. This ensures that the wildcard is interpreted as such. With other operators, the value is interpreted literally.
|
NOT LIKE
|
Is not like. This operator does not match the given pattern. Use this operator if the value in the conditional expression contains a wildcard. This ensures that the wildcard is interpreted as such.
|