Using dollar ($) notation
Dollar ($) notation is used to access object properties in .
Syntax
$<definition>:<data type>{<format>}$
If you are using dollar notation you need to ensure that the value is allocated the correct data type. Dollar notation returns a String type by default.
Permitted data types are:
Binary
Bool
Byte
Date
Decimal
Double
Int
Long
Short
String (default)
Text
The format specification is optional. If the format is specified, the target type of the expression is a string. If the format is not specified, it is the specified data type.
The format specifications correspond to the format strings of the string.format function for the individual types. For more information about the format string, see https://docs.microsoft.com/en-us/dotnet/standard/base-types/composite-formatting#format-string-component.
Examples:
$MaxValidDays:Int{000}$
with the value 42 give the result "042"
$XDateUpdated:Date{t}$
gives "11:16"
NOTE: If you want to use a dollar $ sign in scripts, without it representing access to a column name, you must mask it by doubling.
Example:
In Windows PowerShell scripts, instead of:
theScript.AppendLine("foreach ($Domain in $Domains)")
use:
theScript.AppendLine("foreach ($$Domain in $$Domains)")
Detailed information about this topic
Accessing local object columns
Syntax
$<column name>:<data type>{<format>}$
Examples for use in templates
The Active Directory user display name should comprise of the first and last name of the Active Directory user. The template for ADSAccount.Displayname is:
If $Givenname$<>"" And $Surname$<>"" Then
Value = $Surname$ & " " & $Givenname$
ElseIf $Givenname$<>"" Then
ElseIf $Surname$<>"" then
End If
If an employee is disabled, the leaving date should be set. The template for Person.Exitdate is:
If $IsInActive:bool$ Then
End If
Related topics
Accessing columns of an object connected by a relation
The only relation currently permitted is the foreign key relation.
Syntax
$FK(<foreign key column>).<column name>:<data type>{<format>}$
Example for use in templates:
An Active Directory user’s first name should based on the assigned employee. The template for ADSAccount.Givenname is:
Value = $FK(UID_Person).Firstname$
Related topics
Accessing the old column value
Syntax
$columnname[o]$
Example for use in process step parameters:
Optional process step parameters are not generated if the value is set to Nothing or not assigned in the value template. This makes it possible to limit the number of parameters for target system components. If such a value should be cleared, an empty string should be transferred instead of Nothing.
A value template may look like this:
If $Lastname[o]$ <> $Lastname$ Then
End If
NOTE: For some standard columns such as XDateInserted, XDateUpdated, XUserInserted, XUserUpdated, XOrigin, XIsInEffect, and XMarkedForDeletion, the new values are only mapped after saving the object. This means that when processing the templates, the new column value is always the same as the old value (for example, $XDateUpdated[o]$ = $XDateUpdated$).
Related topics
