PowerExchange for Salesforce User Guide

10.5.4
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Query Properties

Use the

Query

tab to specify a filter condition. You can specify a native filter expression or a platform filter expression.

When you use the native expression, you use the standard Salesforce syntax for filter expressions. You can specify a native expression that use AND, OR, or nested conditions. The expression that you enter becomes the WHERE clause in the query used to retrieve records from the source.

To specify a native expression, use the following syntax:

<Object Name.field> <Operator> <Value>

For example,

Account.Name='John'

Platform expression uses Informatica transformation language. Use the platform filter expression to select specific records from Salesforce resources based on the filter condition that you specify.

The following table describes the properties that you can specify when you use the platform expression filter:

Property	Description
Expression Type	Type of filter expression that you want to use to filter records. Select Platform Expression .
Left Field	Column on which you want to apply the filter condition.
Operator	Simple operators that you can use to filter records. You can select one of the following operators: =, !=, <, <=, >, >=
Right Field	Value based on which you want to filter the records. You can also parameterize the value.

Rename Saved Search

Table of Contents

PowerExchange for Salesforce User Guide

PowerExchange for Salesforce User Guide

Query Properties

Query Properties