You can customize predefined default column formats and create your own additional formats. The default configuration is moved to a configuration buffer during handling. You can retrieve changes from the configuration buffer and restore the default configuration in this way.
You can also use predefined formatting scripts along side formatting types to check values in a column.
|
NOTE: You can get an overview of existing columns in the system with formatting type or formatting scripts in the category One Identity Manager Schema | Templates in Designer. |
You can specify column formats based on predefined formatting types. By combining formatting types with each other, you can obtain the formatting you required.
|
NOTE: Enter the column data, which must be unique when together, into the table definition using multi-column uniqueness. The columns are collected into a unique groups. |
To specify formatting types
Value | Format Type | Permitted values |
---|---|---|
0 | None | No special formatting = default |
1 | IP address | IP address [0-9]³.[0-9]³. [0-9]³.[0-9]³ |
2 | MAC-ID | MACID [0-9,A-F]12 |
4 | Drive letter | Drive letter [A-Z]1: |
8 | Digit | [0-9]+ |
16 | Capital letters | Capital letters |
32 | Server dependent capital letters | (Only included for compatibility) |
64 | NT name | All characters permitted except "!@/\:,“[];|=+*?<>" |
128 | Telephone number | Telephone number [0123456789#/-+*]n |
256 | Exchange name | All characters permitted except "ÄÖÜäöüß“!§$%&\|/<>#*{}[] ²³~^," |
512 | ASCII letters and numbers | All characters of the character set 7-bit |
2048 |
URI |
Uniform resource identifier |
4096 |
Email address |
Valid email address |
|
IMPORTANT: Compile the database to bring the formatting type into effect. |
You can use a formatting script to verify column values. Formatting scripts, as opposed to value templates, are only executed when a value is assigned to the column.
To create a formatting script
Write the script in VB.Net syntax which allows all VB.Net script functions to be used.
|
IMPORTANT: Compile the database to bring the formatting script into effect. |
The value in the column Mail in the ADSAccount table should correspond to SMPT format. If this is not the case, an error message is sent. The formatting script for the column ADSAccount.Mail can be formulated as follows:
Dim str as String = Convert.ToString(Value)
If str.Length > 0 Then
If Not VID_IsSMTPAddress(str) Then
Throw New Exception("""" & str & """ is not a valid SMTP address.")
End If
End If
You can define a list of permitted values in order to limit a column to specific values. Once the column display name has been created, the list of permitted values is no longer valid. Permitted values are supplied for certain data model columns through schema installation.
|
NOTE: If a column is principally enabled for permitted values editing, that means the option Customizing permitted list not allow is not set, then you can add to or extend a value list. |
To specify a list of permitted values
Icon | Meaning |
---|---|
Insert value. | |
Delete value. | |
Change value. | |
Change sort order. |
|
IMPORTANT: Compile the database to bring the list of permitted values into effect. |
Only the values "internal" and "external" should be valid in the input field "Spare field no. 1". The list of permitted values is defined as followed:
1=internal 2=external
The string "intern" is therefore displayed on forms in the program "Manager" for an employee with the value "1".
There is a special control element used in the program "Manager" for displaying columns is defined a list of permitted values. 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 20: 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).
© 2023 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy