There are formatting scripts available for some columns. You can select which formatting script to use from a configuration library. For example, various formatting scripts are provided for checking dates or permitted character strings.
To select a formatting script from the configuration library
-
In the Designer, select One Identity Manager Schema.
-
Select the table and start the Schema Editor with the Show table definition task.
-
Select the column and then the Column properties view.
-
Select the Value calculation tab.
-
In the Formatting script section, click Select from library.
This link is shown only when several formatting scripts are available for a column in the library.
-
The configuration library lists various formatting scripts.
-
To display the formatting script's configuration code, click 
.
-
To accept the formatting script, click OK.
-
Select the Database > Commit to database and click Save.
There may be dependencies between individual values, for example, by using value templates or customizers that require values to be set in a specific order. In the case of One Identity Manager tools the correct order is enforced through blocking or releasing input fields. In the case of data import and when using web service interfaces, the correct order for setting values also has to be ensured.
The following data sources assume the following sequence for specifying the order for setting values:
-
Customizer
The dependencies between columns and an object are stored in customizers.
-
Custom defined dependencies
To define custom dependencies between columns
-
In the Schema Editor, select a table column.
-
In the Column properties view on the Dependencies tab, define the predecessor of this column.
-
Column dependencies due to value templates
In this case, values used by a template (for example, Person.Firstname, Person.Lastname) are set before values that are created by a template (for example, Person.CentralAccount).
If circular dependencies occur whilst determining the order for setting the values, they are stopped at the point of lowest priority.
Related topics
To only allow a specific value in a column, you can define a list with the permitted values. This list of permitted value is resolved once the column's display value has been formatted. For some columns of the One Identity Manager schema, already permitted values are supplied when the schema is installed.
NOTE: You can only enter or extend a list of permitted values for a column if the option Customizing permitted values list is not allowed is not set.
To create a list of permitted values
-
In the Designer, select the One Identity Manager Schema category.
-
Select the table and start the Schema Editor with the Show table definition task.
-
Select the column and then the Column properties view.
-
Select the Value settings tab and enable the Defined list of values option.
-
Click 
and enter the following properties.
-
Value: Value for the value list (technical name).
-
Display value: Name used to display the value. Translate the given text using the ... button.
-
Sort: Sort order of displaying the values in the list.
-
Select the Database > Commit to database and click Save.
IMPORTANT: Compile the database to bring the list of permitted values into effect.
Example:
In the Spare field no. 01 input field for an identity, the values internal and external should be permitted. The list of permitted values is defined as followed:
1=internal 2=external
For an identity with the value 1, the display value internal is shown on the forms in the Manager.
Display columns with permitted values in the Manager
A special control element is used in the Manager to display columns for which a list of permitted values has been defined. The control element is displayed as a simple input field if no list is defined. If a list is defined the control element is shown as a menu.
Figure 10: Input field for list of defined values (with and without defined entries)
The control element is only available for columns on default predefined forms as well as custom columns (usually CustomProperty01-CustomProperty10).
Related topics
Values in multi-values property (MVP) columns are delimited by char(7) or chr(7). Specify other requirements for each value of the MVP column.
To specify requirements for a MVP column
-
In the Designer, select One Identity Manager Schema.
-
Select the table and start the Schema Editor with the Show table definition task.
-
Select the column and then the Column properties view.
-
Select the Value settings tab and set the Multi-value column option.
-
In the Multi-value specification menu, configure the following settings.
-
Unique: Set this option if the value must be unique.
-
Case sensitive: Set this option if the case sensitivity should be taken into account when the value is tested.
-
Accent insensitive: Set this option if accent characters should not be taken into account when the value is tested.
-
Select the Database > Commit to database and click Save.
Related topics
. To delete a value, select the value and click 
. To delete all values, click 
.