Lookup table and relationship attributes

In the Product Master, you can select the lookup table and the relationship type attributes. More facets are available to control the display of these types of attributes.

Lookup table type attributes

When defining any of the following specs, the lookup table value display format and lookup table value display attributes available:
  • File Spec
  • Primary Spec
  • Lookup Spec
  • Secondary Spec
  • Sub-Spec
  • Script Input Spec
Note: The lookup table value display format and lookup table value display attributes are not available for the Destination Spec.
  • Lookup table value display format - This attribute type controls the display format of a lookup table type attribute. The following formatting options are available and you can pick one of the formatting options. By default, look up table type attribute values are displayed using the Primary Key format.
    • Primary Key
    • Display Attribute
    • Primary Key > Display Attribute
    • Lookup Table Name > Primary Key
    • Lookup Table Name > Display Attribute
    • Lookup Table Name > Primary Key > Display Attribute
  • Lookup table value display attribute - This attribute enables you to pick any attribute of the selected lookup table as the display attribute. A list of all the attributes of the selected lookup table is displayed on the spec screen. You can select an attribute as the display attribute from this list. By default, the first attribute in the list is selected when the facet is added. The attribute can be the primary key of the lookup table as well. The lookup table attribute can be indexed or non-indexed.
    The default Lookup table attribute view is a pop-up window. Using the lookupTableProperties section in the config.json file at the $TOP/MDMUI/dynamic/mdmui/ folder, you can change the Lookup table attribute view to a drop-down list.
    Important: To apply the updates to the config.json file, run the updateRtProperties.sh file in the $TOP/mdmui/bin folder.
    • editorMode - Specifies whether the lookup-table editor is displayed as a drop-down or dialog. The possible values are 'dropdown' or 'dialog'.
    • minTypeAheadLength - Specify the minimum number of character you have to type before the lookup-table editor starts displaying suggestions in the drop-down mode.
    • maxItemsCount - Specify the maximum lookup-table entries to fetch from the server in a single server call.
    Lookup table attribute searches based on the value of the Display Attribute or Primary Key. By default, the search preference is Display Attribute, if Lookup Table Value Display Attribute is not set in the Admin UI. Lookup table drop-down list displays formatted value depending on the Lookup Table Value Display Format in the Admin UI. By default, if no format is specified the Primary Key is displayed . The Lookup table drop-down list searches based on the Display Attribute only.
    Note: For Admin UI, by default the search is for both Primary key and display attribute (if set).

Relationship type attributes

When defining any of the following specs, the relationship value display format attribute is available:
  • File Spec
  • Primary Spec
  • Lookup Spec
  • Secondary Spec
  • Sub-Spec
  • Script Input Spec
The relationship value display format attribute enables you to select the display format of the relationship attribute values. This optional attribute is available only for relationship type attributes. After an import, the value of the relationship attribute is displayed only for items. The following formatting options are available and you can pick one of the formatting options. By default, relationship attribute values are displayed using the Catalog Name > Primary Key > Display Attribute format.
  • Primary Key
  • Display Attribute
  • Primary Key > Display Attribute
  • Catalog Name > Primary Key
  • Catalog Name > Display Attribute
  • Catalog Name > Primary Key > Display Attribute