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)

Boolean Constants

• Purpose: Returns pure values for Boolean logic.

• Syntax:

True

False

Null (empty)

• Example: You want to set the target DisplayName to the source value only if it is Null

• if(T.DisplayName = Null, S.DisplayName, T.DisplayName)

case

• Purpose: Branching logic flow statement, evaluates different statements based on a given conditions, evaluated in order.

• Syntax: case(condition, value, condition, value, ...)

• Example: You want to set the department attribute to a standard, but the source value does not match your new standard. Departments in the source may be "IT" and "FIN", but in the target they need to be "Info Tech" and "Finance". Use of the case statement below will set department to "Info Tech" when the source department equals "IT" and set the department to "Finance" when the source department equals "FIN".

Target Attribute    : Department

Value        : case(S.Department = "IT","Info Tech", S.Department = "FIN","Finance")

Condition    : Null

if

• Purpose: Returns a specified value if given condition is true, otherwise returns a different specified value.

• Syntax:  if(condition, value1, value2)

returns value1 when condition evaluates to True, otherwise returns value2

•  

• Example: You need to set your display name to include (MGR), but only if the title of the user contains (Manager). For non-managers, display name is simply first name and last name. The value expression below uses an If statement to check if the source attribute title contains the word "Manager".  If it contains "Manager", it will append " (MGR)" to the end of the first and last names.

Target Attribute    : DisplayName

Value        : if(contains(s.title, "Manager"), s.firstName+s.lastName + " (MGR)", s.firstName + s.lastName)    

Condition    : Null

Math

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)

Boolean Constants

• Purpose: Returns pure values for Boolean logic.

• Syntax:

True

False

Null (empty)

• Example: You want to set the target DisplayName to the source value only if it is Null

• if(T.DisplayName = Null, S.DisplayName, T.DisplayName)

case

• Purpose: Branching logic flow statement, evaluates different statements based on a given conditions, evaluated in order.

• Syntax: case(condition, value, condition, value, ...)

• Example: You want to set the department attribute to a standard, but the source value does not match your new standard. Departments in the source may be "IT" and "FIN", but in the target they need to be "Info Tech" and "Finance". Use of the case statement below will set department to "Info Tech" when the source department equals "IT" and set the department to "Finance" when the source department equals "FIN".

Target Attribute    : Department

Value        : case(S.Department = "IT","Info Tech", S.Department = "FIN","Finance")

Condition    : Null

if

• Purpose: Returns a specified value if given condition is true, otherwise returns a different specified value.

• Syntax:  if(condition, value1, value2)

returns value1 when condition evaluates to True, otherwise returns value2

•  

• Example: You need to set your display name to include (MGR), but only if the title of the user contains (Manager). For non-managers, display name is simply first name and last name. The value expression below uses an If statement to check if the source attribute title contains the word "Manager".  If it contains "Manager", it will append " (MGR)" to the end of the first and last names.

Target Attribute    : DisplayName

Value        : if(contains(s.title, "Manager"), s.firstName+s.lastName + " (MGR)", s.firstName + s.lastName)    

Condition    : Null

Value Comparison

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)

Boolean Constants

• Purpose: Returns pure values for Boolean logic.

• Syntax:

True

False

Null (empty)

• Example: You want to set the target DisplayName to the source value only if it is Null

• if(T.DisplayName = Null, S.DisplayName, T.DisplayName)

case

• Purpose: Branching logic flow statement, evaluates different statements based on a given conditions, evaluated in order.

• Syntax: case(condition, value, condition, value, ...)

• Example: You want to set the department attribute to a standard, but the source value does not match your new standard. Departments in the source may be "IT" and "FIN", but in the target they need to be "Info Tech" and "Finance". Use of the case statement below will set department to "Info Tech" when the source department equals "IT" and set the department to "Finance" when the source department equals "FIN".

Target Attribute    : Department

Value        : case(S.Department = "IT","Info Tech", S.Department = "FIN","Finance")

Condition    : Null

if

• Purpose: Returns a specified value if given condition is true, otherwise returns a different specified value.

• Syntax:  if(condition, value1, value2)

returns value1 when condition evaluates to True, otherwise returns value2

•  

• Example: You need to set your display name to include (MGR), but only if the title of the user contains (Manager). For non-managers, display name is simply first name and last name. The value expression below uses an If statement to check if the source attribute title contains the word "Manager".  If it contains "Manager", it will append " (MGR)" to the end of the first and last names.

Target Attribute    : DisplayName

Value        : if(contains(s.title, "Manager"), s.firstName+s.lastName + " (MGR)", s.firstName + s.lastName)    

Condition    : Null

Boolean Combinations

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)

Boolean Constants

• Purpose: Returns pure values for Boolean logic.

• Syntax:

True

False

Null (empty)

• Example: You want to set the target DisplayName to the source value only if it is Null

• if(T.DisplayName = Null, S.DisplayName, T.DisplayName)

case

• Purpose: Branching logic flow statement, evaluates different statements based on a given conditions, evaluated in order.

• Syntax: case(condition, value, condition, value, ...)

• Example: You want to set the department attribute to a standard, but the source value does not match your new standard. Departments in the source may be "IT" and "FIN", but in the target they need to be "Info Tech" and "Finance". Use of the case statement below will set department to "Info Tech" when the source department equals "IT" and set the department to "Finance" when the source department equals "FIN".

Target Attribute    : Department

Value        : case(S.Department = "IT","Info Tech", S.Department = "FIN","Finance")

Condition    : Null

if

• Purpose: Returns a specified value if given condition is true, otherwise returns a different specified value.

• Syntax:  if(condition, value1, value2)

returns value1 when condition evaluates to True, otherwise returns value2

•  

• Example: You need to set your display name to include (MGR), but only if the title of the user contains (Manager). For non-managers, display name is simply first name and last name. The value expression below uses an If statement to check if the source attribute title contains the word "Manager".  If it contains "Manager", it will append " (MGR)" to the end of the first and last names.

Target Attribute    : DisplayName

Value        : if(contains(s.title, "Manager"), s.firstName+s.lastName + " (MGR)", s.firstName + s.lastName)    

Condition    : Null