Adding Qualified Tables and Fields 

Use

You can add customized qualified tables and fields to your GDS repository which is specific to your sphere of business.

Procedure

...

...

       1.      Login to the MDM Console and unload the repository.

       2.      Add a new qualified table to the repository.

       3.      Add a lookup field (qualified flat) to the new table.

       4.      Define the qualifier field according to specific requirements.

       5.      Load the repository with indices using the MDM Console.

       6.      Log in to the MDM Data Manager.

       7.      Select the new qualified table and add one record.

The value should be the same as the table in single form.

For example,  if the table name is Packaging Materials then the value should be Packaging Material. This value is only for display purposes.

       8.      Open the “\GDS\Configurations\Metadata\MetadataConfiguration_1Sync_User.xml” file and add the following tag:

<MDElement name="{table name}" type="Table" permission="User" managed="false"/> into the <Tables>

       9.      If one of the qualified fields in the table is unique, add  (unique=”true”), into the tag, for example:

<MDElement name="{table code}" type="Table" permission=" User" managed="false"><childElements><MDElement type="Field" permission=" User" name="{Field code}" managed="true" unique="true"/></childElements></MDElement>

   10.      Save the file.

   11.      Add the relevant XSLT transformation code (see example below).

   12.      Restart the GDS application and the MDMconnector using the Visual Administrator.

   13.      Log in to the GDS Console.

   14.      Assign the qualifier fields to one or more tabs.

More information: UI Configurations → Configuring Tabs

Example

Adding a Qualified Field (Repository View)

XSLT Code

●      <xsl:for-each select="$message_Data/Item[$itemPosition]/Table[@Name='AlternateItemIdentifications' and @ReferencePath='TMData~AlternateItemIdentification']/Record">

●      <xsl:variable name="ID">

●      <xsl:value-of select="@ID"/>

●      </xsl:variable>

●      <alternateItemIdentification>

●      <agency>

●      <xsl:value-of select="$message_Data/Item[$itemPosition]/Table[@Name='AlternateItemIdentificationMaintenanceAgencyCodes' and @ReferencePath='TMData~AlternateItemIdentification^AlternateItemIdentifications~MaintenanceAgency']/Record[@ReferenceID=$ID]/Field[@Name='Name']/ComplexValue/@Key"/>

●      </agency>

●      <id>

●      <xsl:value-of select="Field[@Name='AlternateItemNumber']/ComplexValue/Value"/>

●      </id>

●      </alternateItemIdentification>

●      </xsl:for-each>