Adding Keys

Keys are identifiers of MDM dictionary records. Keys can be unique and non-unique.

Unique Keys

NOTE. A key may contain several attributes if dictionary does not have single unique attribute.

To add a unique key:

Click the Add button.
Select the Add item in the context menu on the free area of the Unique Keys tab.
Double-click the free area of the Unique Keys tab with the main mouse button.

The Unique Key Properties dialog box opens:

Set up unique key properties:

Name. Enter the unique key name.
Identifier. Enter the identifier of the unique key. Only English letters, numbers and underscores are allowed; spaces are not allowed.
Attribute Entries. The list contains the checkboxes corresponding to dictionary attributes, including system attributes: Name and Order. Select one of several attributes that must be included into a unique key.

To edit properties of the selected unique key:

Click the Edit button.
Select the Edit item in the unique key's context menu.
Double-click the name of the unique key with the main mouse button.

Enter required changes in the Unique Key Properties dialog box that opens.

To delete the selected unique key:

Click the Delete button.
Press CTRL + DELETE.
Select the Delete item in the unique key's context menu.

A confirmation is required.

Non-Unique Keys

A non-unique key is an additional identifier for MDM dictionary records. It is used to:

To add a non-unique key:

Click the Add button.
Select the Add item in the context menu on free area of the Non-Unique Keys tab.
Double-click the free area of the Non-Unique Keys tab with the main mouse button.

The Non-Unique Key Properties dialog box opens:

Set non-unique key properties:

Name. Enter non-unique key name.
Identifier. Enter non-unique key identifier. Only English letters, numbers and underscores are allowed; spaces are not allowed.
Attribute Entries. The list contains checkboxes corresponding to all dictionary attributes. Select one or several attributes that must be included into a non-unique key.

To edit properties of the selected non-unique key:

Click the Edit button.
Select the Edit item in the non-unique key's context menu.
Double-click the name of the non-unique key with the main mouse button.

Enter the required changes in the Non-Unique Key Properties dialog box that opens.

To delete the selected non-unique key:

Click the Delete button.
Press CTRL + DELETE.
Select the Delete item in the non-unique key's context menu.

A confirmation to execute the operation is requested.

NOTE. The option is available by means of the Fore language only in table MDM dictionaries and composite table MDM dictionaries.

A non-unique index in the table MDM dictionary child table enables the user to execute queries.

To create a non-unique index:

Create or get the existing non-unique key in the table MDM dictionary.
Cast the obtained key to the IMetaIndex interface.
Set the IMetaIndex.Enabled property to True.
Save changes.

As a result, a non-unique index is created in the table MDM dictionary child table based on the non-unique key from the table MDM dictionary.

NOTE. If the non-unique key in the table MDM dictionary contains imported attributes or attributes with multiple values, a non-unique index cannot be created on its basis.

To get the example, see the Creating a Non-Unique Index in Table MDM Dictionary Table section.