The Non-Unique Keys Page: MDM Dictionary

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

Setting up non-unique keys is different in the web application and in the desktop application.

Web application Desktop application

To create and set up non-unique keys use the Non-Unique Keys page of the dictionary structure setup wizard:

To create and set up non-unique keys use the Non-Unique Keys tab in the MDM dictionary window opened for edit.

To add a non-unique key:

In the web application click the Add button. A new key will be added to the list of non-unique keys. Key name and identifier will be set by default. The default value of the Name property - ITEM<Number>. The default value of the Identifier property is UI<Number>.
In the desktop application:

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

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 Latin characters, 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:

In the web application change properties in corresponding columns of the required non-unique key on the Non-Unique Keys page of the MDM dictionary wizard.
In the desktop application:

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.

Make necessary changes in the Non-Unique Key Properties dialog box.

To delete the selected non-unique key:

In the web application click the Delete button.
In the desktop application:

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.

To change the number of displayed properties in the web application, click the Settings button and select or deselect the checkbox next to property names.

The function is available using the Fore language. A non-unique index in the 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 MDM dictionary.
Cast the obtained key to the IMetaIndex.
Set the IMetaIndex.Enabled property to True.
Save changes.

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

NOTE. If the non-unique key in the 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 MDM Dictionary Table section.

Adding Non-Unique Keys