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.
|