For columns with the data types Double, Decimal, Int, Long or Short, you can define the number of decimal places for displaying values in the user interface.
In columns with the data types Int, Long or Short, the decimal point is shifted in the value display when the decimal places are specified. In columns with the data types Double or Decimal, the value is displayed with the corresponding number of places after the decimal point. Take this behavior into account when calculating with different data types.
To define the number of decimal places
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: If there is a column or column combination for a table that needs to be unique, you define multi-column uniqueness in Designer. For more information, see Defining unique columns. |
To specify formatting types
Value | Formatting 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 | Number | [0-9]+ |
16 | Uppercase | Uppercase |
32 | Uppercase server dependent | (only maintained for compatibility reasons) |
64 | NT name | All characters are permitted except for „!@/\:,“[];|=+*?<>“ |
128 | Phone | Phone [0123456789#/-+*]n |
256 | Exchange name | All characters are permitted except for „ÄÖÜäöüß“!§$%&\|/<>#*{}[] ²³~^,“ |
512 | ASCII characters and numbers | All characters from the 7-bit ASCII character set |
2048 |
URI |
Uniform Resource Identifier |
4096 |
Email address |
Valid email address |
|
IMPORTANT: Compile the database to implement the formatting type. |
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
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 administration tools the correct order is enforced through blocking or releasing input fields. In the case of data import and when using SPML and web service interfaces, the correct order for setting values also has to be safeguarded.
The following data sources assume the following sequence for specifying the order for setting values:
The dependencies between columns and an object are stored in customizers.
To define custom dependencies between columns
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 aborted at the point of lowest priority.
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy