in Salesforce by (32.2k points)

How to add a filter condition in a source transformation when the source is a Salesforce object?

1 Answer

0 votes
by (32.2k points)

When the source is a salesforce object, defining the filter condition under the Filter option available under Query Options won’t work. The Filter condition needs to be defined under SOQL Filter Condition available under Advanced tab of source transformation.

The Filter option under Query Options tab can be used only if the filter condition needs to be parameterized.

Alternatively, the Source Type can be selected as Query and the filter condition can be passed in the source query defined.

Related questions

0 votes
0 votes
asked Sep 26, 2019 in Salesforce by Robin (14.6k points)
0 votes
asked Sep 27, 2022 in Salesforce by SakshiSharma (32.2k points)
0 votes
+1 vote
asked Nov 25, 2021 in Salesforce by DavidAnderson (9.0k points)