Table scripts help you to define actions that are executed before or after saving, loading, or discarding an object. In this way, substantial changes or value checks that cannot be easily done with formatting rules or templates, can be made to an object by running a table script before it is saved. After the object is saved, changes to other objects can be made or task and processes can be generated with table scripts, for example. The side effect and tasks defined in the Customizer are applied following the table scripts.
You can customize predefined default table scripts and create your own additional table scripts. Table scripts are stored in VB.Net syntax which allows use of all VB.Net script functions.
To add table scripts
- In the Designer, select the One Identity Manager schema category.
- Select the table and start the Schema Editor with the Show table definition task.
-
In the Table properties view, select the Table scripts tab and create the required scripts.
Table 23: Table scripts
| Script (OnDiscarded) |
The script is run after the object is discarded. |
| Script (OnDiscarding) |
The script is run before the object is discarded. |
| Script (OnLoaded) |
The script is run after the object is loaded. |
| Script (OnSaved) |
The script is run after the object is saved. |
| Script (OnSaving) |
The script is run before the object is saved. |
IMPORTANT: Compile the database to bring the table scripts into effect.
Related topics
To transport, for example, predefined reports, processes, workflows, or mail definitions with a complete system configuration transport, the objects require a primary key with a module GUID. These are objects are identified as part of the system configuration through the module GUID.
Syntax
The table primary key has the CCC-[0-9,a-f](32) format.
NOTE: Entries with a module GUID are transferred automatically to the transport package when a transport of the entire system configuration is created.
You can use the following table definition settings for generating a module GUID:
- If the Module GUID permitted and Module GUID required options are enabled, the objects have to get a module GUID. The objects in this type of labeled tables are given the CCC module prefix.
- If only the Module GUID permitted option is enabled, the objects can get a module GUID in the required format. By default, the objects obtain a default GUID in the [0-9,a-f](8-4-4-4-12) format. Create the objects with the CCC prefix if they should obtain a module GUID. You can do this using the Object Browser.
Example
- The Module GUID required and Module GUID permitted options are enabled on the DialogGroup table. When creating a new permissions group, the primary key is automatically generated in the format of a module GUID.
- For the AERole table only the Module GUID permitted option is set. To ensure that your own application roles are added to the transport package, create the application roles in the Object Browser with a module GUID.
NOTE:
- In the default case, the table's primary key is created with a default GUID. To subsequently change a default GUID to a module GUID, you use the Object Browser.
- GUIDs in tables that are labeled with IsNoReload = 1 in the QBM_VHeavyLoadTables view cannot be changed.
IMPORTANT: Do not execute the following steps for production databases. Only perform these steps within the maintenance window. Otherwise, this could lead to inconsistent data.
To change a default GUID to a module GUID
- In Object Browser select the object for which you want to change the default GUID.
- Display the Properties context menu.
- On the Methods tab select the SwitchToModuleGuid() method and click Execute.
To change a module GUID to a default GUID
- In Object Browser select the object for which you want to change the module GUID.
- Display the Properties context menu.
- On the Methods tab select the SwitchToNormalGuid() method and click Execute.
Related topics
If there is a column or column combination for a table that needs to be unique, you define multicolumn uniqueness in the Designer. The columns are collected into a unique groups.
Examples
- For the Hardware table, you must ensure that the name of the hardware is unique. For the Hardware table, a Hardware unique group with the Ident_Hardewarelist column is created.
- For the ADSDomain table, the combination of the domain identifier and its defined name must provide unique values. For the ADSDomain table, an ADSDomain unique group with the Ident_Domain and DistinguishedName columns are created.
To group together columns in a unique group
- In the Designer, select the One Identity Manager schema category.
- Select the table and start the Schema Editor with Show table definition.
-
In the Table properties view, select the Multicolumn uniqueness tab and click 
.
-
Enter the following information.
Table 24: Table properties for multicolumn uniqueness
|
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. This option can only be set if all columns in the group can be empty.
- If the option is set, empty values are permitted in the relevant columns. If at least on of the relevant columns is not empty, uniqueness is tested. If all the group's columns are empty, uniqueness is not tested. This allows several data records to be inserted that all have empty group columns.
- If this option is not set, empty values are permitted but only once for each column. Several data records whereby all the group's columns are empty, cannot be inserted.
NOTE: Violations of the unique group are not recognized if one of the foreign keys to be inserted and an existing foreign key are empty and otherwise the group's other columns to test match. |
TIP: To prevent empty values in a column, define a minimum length for the column in the column definition.
Related topics
