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.
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
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)
Purpose: Combinations of operations can be achieved with the following.
Syntax:
And
Or
! (not)
Example: Action = "create" or (Action = "update" and Target.HasCreateStamp)
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)
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
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
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.
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
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)
Purpose: Combinations of operations can be achieved with the following.
Syntax:
And
Or
! (not)
Example: Action = "create" or (Action = "update" and Target.HasCreateStamp)
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)
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
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
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.
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
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)
Purpose: Combinations of operations can be achieved with the following.
Syntax:
And
Or
! (not)
Example: Action = "create" or (Action = "update" and Target.HasCreateStamp)
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)
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
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
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.
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
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)
Purpose: Combinations of operations can be achieved with the following.
Syntax:
And
Or
! (not)
Example: Action = "create" or (Action = "update" and Target.HasCreateStamp)
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)
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
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
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center