Variables
There are 2 different variables:
System Variables
Statement returning system data. Below the entire list with syntax and description:
System Variable | Syntax | Description |
---|---|---|
Current Date | $CURRENTDATE | returns the current system date |
Current Domain Id | $CURRENTDOMAIN.ID | returns a string containing the Id of the current Domain |
Current Domain Name | $CURRENTDOMAIN.NAME | returns a string containing the name of the current Domain |
Current User Logon Date | $CURRENTUSER.CURRENTLOGONDATE | returns a date time containing the current logon date for the current User |
Current User Departments | $CURRENTUSER.DEPARTMENTS | returns a string containing a list of the departments for the current User |
Current User Email | $CURRENTUSER.EMAIL | returns a string containing the email of the current User |
Current User Group Ids | $CURRENTUSER.GROUPIDS | returns a string containing the Ids of the Group the current User belongs to |
Current User Group Name | $CURRENTUSER.GROUPNAMES | returns a string containing the names of the Groups of the current User |
Current User Last Logon Date | $CURRENTUSER.LASTLOGONDATE | returns a date time containing the last logon date for the current user |
Current User Logon Name | $CURRENTUSER.LOGONNAME | returns a string containing the logon name of the current User |
Current User Name | $CURRENTUSER.NAME | returns a string containing the name of the current User |
Current User Surname | $CURRENTUSER.SURNAME | returns a string containing the surname of the current User |
Current User Id | $CURRENTUSER.USERID | returns a string containing the system-id of the current User |
Logical Column Variables
Statement based on Calculated Logical Columns.
After creating a Calculated Logical Column in Design Mode, there's a tooltip near the Select Type, to copy the variable name (1) and, after the operation was successful (2), paste it in a Formula Editor (3):
Syntax
The variable's name is generated by:
- two dollars symbols ($$)
- the name assigned by the User
- no special characters
- underscore symbol instead spaces
$$Calculated_Logical_Column
Usage
It's possible to use Calculated Logical Columns variables mainly in Design Mode Layout formulas.
Example:
1 2 3 4 5 |
|