SharePoint components - business processes without development, InfoPath, SharePoint Designer or workflows. SharePoint Services, SharePoint Foundation & SharePoint Server 2010-2016.

Training

Event Calendar

AND / OR Conditions

Multiple AND / OR conditions can be chained together. It is critical to undestand 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

AND conditions chain together / OR conditions start a new rule

When chaining together multiple conditions, the OR logical operator starts a new section.

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 Var 3 = 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)

AND Var1 = 1

AND Var2 = 2

AND Var3 = 3

OR Var1 = 1

AND Var2 = 2

AND Var3 = 3


Example G:

CREATE this logic:

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

AND Var1 = 1

AND Var3 = 3

OR Var1 = 1

AND Var4 = 4

OR Var2 = 2

AND Var3 = 3

OR Var 2 = 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/28/2016 10:02 PM
Be the first to add a comment to this article
 
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.