If a value template references a value from another object, it can be accessed using the FK relation.
Figure 11: Effect of Cross Object Value Templates
If, for example, the surname of an Active Directory user account (ADSAccount.Surname) is derived from the surname of an employee (Person.Lastname), enter the template for the column ADSAccount.Surname as follows:
Value = $FK(UID_Person),Person.Lastname$
If the employee’s surname changes, the last name of the Active Directory user changes, too. The column Person.Lastname is therefore the sender and the column ADSAccount.Surname is the receiver. The relation is mapped in the table DialogNotification as follows:
Person.Lastname --> ADSAccount.Surname
You can customize the column formats to your requirements and create your own additional formats. You can also use predefined formatting scripts along side formatting types to check values in a column.
|
Note: You can get an overview of the existing columns in the system with predefined formatting types or formatting scripts in Designer in One Identity Manager Schema | Formatting rules. |
If there is a column or column combination for a table that needs to be unique, you define multicolumn uniqueness in Designer. The columns are collected into a unique groups.
To group together columns in a unique group
In the Table properties view, select the Multicolumn uniqueness tab and click .
Enter the following information.
Property |
Description | ||
---|---|---|---|
Unique group |
Name of the unique group of columns. | ||
Columns |
Enable the columns that must be unique when combined. | ||
Ignore empty values |
Specifies whether empty values are permitted in a unique group. If all the columns in one group are empty, group uniqueness cannot be tested. If this option is not set, empty values are permitted but only once for each column.
|
You can use the column definition to control the length of the values to be entered. For example, the login name of an Active Directory user account is limited to a maximum of 20 characters. You can also use the column definition to define which columns are required columns.
To define the length of a column
Select the Value calculation tab and edit the following properties.
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy