How To Add Compound Logic To Filters

Document created by paul_pasko Employee on Oct 18, 2011
Version 1Show Document
  • View in full screen mode
When creating a Connection Operation, you may have the need to add advanced logic using compound conjunction or disjunction statements.  This is often the case when working with Salesforce Objects within the Filters tab.  Keep in mind that having the ability to use AND or OR logic is often Connector API specific and may not be availble depending on the connector used.
When working with logical sub groups, the top-most sub group defines the type of logical connection (AND or OR) between the subsequent logical sub groups.
For example, let’s assume we want to produce the following logic:

(ExpressionA OR ExpressionB) AND (ExpressionC AND ExpressionD)

To accomplish this, add a logical sub group under the main Filter and define it as a Logical – AND.  Then under this top-level Logical – AND, add a Logical – OR with two contained Expressions and then a Logical – AND with two contained Expressions.

0EM40000000PDoJ

By observing the SQOL (0EM40000000PDoO), you can see how this logic is interpreted.  Understand that the 'Show SOQL' option is only available within the SF Connector.

0EM40000000PDoT

Similarly, let’s assume we want to produce the following logic:

(ExpressionA OR ExpressionB) OR (ExpressionC AND ExpressionD)

To accomplish this, add a logical sub group under the main Filter and define it as a Logical – OR.  Then under this top-level Logical – OR, add a Logical – OR with two contained Expressions and then a Logical – AND with two contained Expressions.

0EM40000000PDoY

By observing the SQOL (0EM40000000PDod), you can see how this logic is interpreted.  Understand that the 'Show SOQL' option is only available within the SF Connector.


0EM40000000PDoi
2 people found this helpful

Attachments

    Outcomes