Tutorial

AND / OR Conditions

Multiple AND / OR conditions can be chained together. It is critical to understand how the system interprets these rules.

Build a test example like the one demonstrated to experiment with chained conditions or study the pattern described below.

In some cases it is necessary to use more than one action to handle all possible conditions.

Instructions

Be careful when chaining multiple AND and OR conditions!

When chaining together multiple conditions, each new condition is handled in comparison to the entire preceding set of condtions.

Imagine that the whole statement preceding the new condition always gets enclosed in parenthesis like this:

(((((CONDITION 1) OR CONDITION 2) AND CONDITION 3) OR CONDITION 4) OR CONDITION 5)

If you chain only AND or OR conditions together things work clearly, but you can get tripped when combining AND and OR conditions.

If you need to evaluate complex condition using both AND and OR operators here is some strategy to consider:

  • Break one action up into multiple actions. Handle your OR situations by creating an action for each situation that you cover normally by using the OR operator.
  • Putting the OR conditions first sometimes can make it easier to build your logic.
  • Create a calculated field to evaluate the composite conditions and return YES or NO. You can fully control the nesting of conditions with this approach.

EXAMPLES:


Example A:

AND Var1 = 1

AND Var2 = 2

  • Evaluates as ((Var1 = 1) AND Var2 = 2)

Example B:

AND Var1 = 1

OR Var2 = 2

  • Evaluates as ((Var1 = 1) OR Var2 = 2)

Example C:

AND Var1 = 1

AND Var2 = 2

OR Var3 = 3

  • Evaluates as (((Var1 = 1) AND Var2 = 2) OR Var3 = 3)

Example D:

AND Var1 = 1

OR Var2 = 2

AND Var3 = 3

OR Var4 = 4

  • Evaluates as ((((Var1 = 1) OR Var2 = 2) AND Var3 = 3) OR Var4 = 4) 

Example E:

AND Var1 = 1

AND Var2 = 2

OR Var3 = 3

AND Var4 = 4

OR Var5 = 5

  • Evaluates as (((((Var1 = 1) AND Var2 = 2) OR Var3 = 3) AND Var4 = 4) OR Var5 = 5)

Example F:

CREATE this logic:

Evaluate (Var1 = 1) AND (Var2 = 2) AND (Var3 = 3 OR Var4 = 4)

In this case, put the OR conditions first.

AND Var3 = 3

OR Var4 = 4

AND Var1 = 1

AND Var2 = 2

Another approach:

Make TWO actions to easily cover the OR situation:

Action 1:

AND Var1 = 1

AND Var2 = 2

AND Var3 = 3

Action 2:

AND Var1 = 1

AND Var2 = 2

AND Var4 = 4


Example G:

CREATE this logic:

Evaluate (Var1 = 1 OR Var2 = 2) AND (Var3 = 3 OR Var4 = 4)

Split this into multiple actions:

Action 1

AND Var1 = 1

AND Var3 = 3

Action 2

AND Var1 = 1

AND Var4 = 4

Action 3

AND Var2 = 2

AND Var3 = 3

Action 4

AND Var2 = 2

AND Var4 = 4

 

Summary

Using conditions in actions is an critical part of the Infowise workflow functionality. Be certain to have a firm grasp on how chained conditions are interpreted to avoid unexpected headaches!

Last modified: 8/30/2017 2:57 PM
3 comments [latest: 10/10/2017 3:00 PM]
Jeff Isbell [10/10/2017 2:57 PM]
Is this a feature/functionality of Premise InfoWise, or is it also available in the 365/Cloud environment? I cannot see the InfoWise items under "Permissions and Management" in the list details I am looking at on my side.
Vladi Gubler [10/10/2017 3:00 PM]
Jeff: both O365 and on-prem. In O365 you should access the app from the List ribbon's Design button.
 
Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.