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 > Save 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 employee, the values internal and external should be permitted. The list of permitted values is defined as followed:
1=internal 2=external
For an employee 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 > Save to database and click Save.
Related topics
You can only define bitmasks for columns with theint type.
NOTE: You can only enter or extend a bitmask for a column if the option Customizing bitmasks is not allowed is not set.
To create a bitmask
-
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 Defined bitmask option.
-
Under Sort criteria of bitmask, select the sort criteria for displaying the value.
You have the following options:
-
Click and enter the following properties.
-
Select the Database > Save to database and click Save.
Related topics
Full-text searching uses an external search index, which returns an object key as result. The object key is used to run a search query in the database. This database search query takes the permissions of the logged in user into account during the search. A maximum of 1000 objects can be returned by through the search index.
The One Identity Manager full text search can be used in the Web Portal and in the Manager. For more information, see the One Identity Manager Web Designer Web Portal User Guide and the One Identity Manager User Guide for One Identity Manager Tools User Interface.
-
Prerequisites for using full text search is an application server installed with the search service.
-
If you run the Web Portal directly over an application server installed with the search service, you can use the full text search immediately.
-
If you are working with the Web Portal and an application server without a search service installed or with a direct database connection, you will need to enter an application server with a search service in the Web Portal configuration file. Full text search is available in the Web Portal once this has been done.
-
To use full text search in the Manager, you must run the Manager over an application server with an installed search service.
For more information about installing an application server and configuring the Web Portal for full-text search, see the One Identity Manager Installation Guide.
The following applies for the configuration of the full text search:
-
The columns XDateInserted, XDateUpdated, and XObjectKey must be available if you want to index a table or database view for full text search.
-
Columns for full text searching must be weighted. Increasing weighting results in a higher position in the search results. The default installation provides columns for the full-text search with a weighting of 1.
Example:
The column Person.CentralAccount is weighted with the value 1. The column ADSAccount.SAMAccountName is weighted with the value 0.5. This results in the employee being listed before the user account in the full text search.
-
Only columns with the .Net data types string or text can be included in the full-text search.
Exception: Columns that contain a list of permitted values, can always be included to the full text search.
-
Columns of tables with the Work tables or Historical transaction data usage type cannot be included in the full-text search.
-
Columns of assignment tables (M:N tables, M:all tables) cannot be included to the full-text search.
The search service indexes the following:
-
Column content
-
Foreign key column display value
-
Display values for lists of permitted values
-
Translation for every active language
-
Object display value, if the table's primary key column is configured for full text search
The object's display value comes from the display pattern defined for the table. The display value's weighting comes from the table's primary key column weighting
Example:
The Person.UID_Person column is configured for full-text search. The display pattern of the Person table is defined as %InternalName% (%CentralAccount%).
So the display value of Clara Harris (CLARAH) is indexed for the employee Clara Harris.
The searched index is updated when changes are made to a table with indexed columns, to referenced tables or translations.
Certain important columns are already indexed for full text search in the default installation. You configure more columns for full text searching if you require.
To configure a column for full text search
-
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 Column tab and edit the Index weighting property.
-
If the value is less than or equal to 0, no indexing takes place.
-
If the value is greater than 0, the data value is indexed.
-
Select the Database > Save to database and click Save.
Related topics
. To delete a value, select the value and click
. To delete all values, click
.