On Demand Migration Current - Active Directory - Directory Sync Advanced Mapping Guide

Operators

Operators are used to manipulate or compare values. You can do basic Math, Value Comparisons, and conditional flow control with "if" and "case" statements. You can combine operations and compare with Boolean operators.

Math

• Purpose: The following can be used to perform calculations of numeric values or combine string-based values.

• Syntax:

  + : Add numbers or concatenate strings

  − : Subtract numbers

  * : Multiply numbers

  ∕  : Divide numbers

• Note: Spaces are needed between symbols and values.

• Example 1: S.FirstName + S.SN

• Example 2: S.GivenName + "." + S.LastName

• Example 3: 12 = 5 + 7

Value Comparison

• Purpose: The following operators return True or False when comparing values.

• Syntax:

  = : Are two values are equal?

  > : Is the left value greater than the right value?

  >= : Is the left value greater than or equal to the right value?

  < : Is the left value is less than the right value?

  <= : Is the left value less than or equal to the right value?

  != : Is the left value not equal to the right value?

• Note: Spaces are needed between symbols and values.

• Example    : if(length(S.GivenName) > 10, S.GivenName, S.sn)

Boolean Combinations

• Purpose: Combinations of operations can be achieved with the following.

• Syntax:

  And    

  Or

  ! (not)

• Example: Action = "create" or (Action = "update" and Target.HasCreateStamp)