Target Destination Filter

A target destination filter is optional. It relies on a source specific syntax for filtering out records from your target. The filter can reference execution parameters.

Source	Definition
Salesforce	For Salesforece syntax is the SOQL where clause (without the where expression)
Dynamics	For Dynamics syntax is the OData $filter clause (without the $filter=expression)
Cinchy	For Cinchy syntax is the CSQL where clause (without the where expression)
SqlServer	For SqlServer the syntax is the T-SQL where clause (without the where expression)

There can only be one <Filter> for each source or target. To specify more than one condition, use AND/OR to allow logical combination of multiple expressions.

Filter Examples

Example 1: Filtering only target records where the Assignee is Null.

Example 2: Filtering only target records where the Override ID is not Null.

Example 3: Filtering only target records from a specific source.