Data Director Implementation Guide

10.4

Back Next

Lookup Tables With Subtype Column

A single lookup table can be used to store lookup values for several different code types.

In this case, the lookup table has a subtype column that identifies the code type.

Use of a lookup table with many lookup types is configured as shown in the following example.

<column columnUid="C_AUTOMOBILE|DOORS_CODE" editStyle="FIELD" horizontalStyle="SMALL">
      <columnLookup lookupFKUid="C_LU_AUTO_ATTR|CODE"       
            lookupNameUid="C_LU_AUTO_ATTR|DISPLAY_NAME">
         <subTypeQualifier columnUid="C_LU_AUTO_ATTR|ATTR_TYPE"> 
            <filter> 
               <value>Doors</value> 
               <value>Style</value> 
            </filter> 
         </subTypeQualifier> 
      </columnLookup>
   </column>

In this example, column C_AUTOMOBILE|DOORS_CODE is a lookup column. Only values in the lookup table with ATTR_TYPE="Doors" are used for this lookup.

Lookup localization can also be combined with lookup sub-types, as shown in the following example.

<column columnUid="C_AUTOMOBILE|DOORS_CODE" editStyle="FIELD" horizontalStyle="SMALL">
      <columnLookup lookupFKUid="C_LU_AUTO_ATTR|CODE" 
         lookupNameUid="C_LU_AUTO_ATTR|DISPLAY_NAME">
         <subTypeQualifier columnUid="C_LU_AUTO_ATTR|ATTR_TYPE"> 
            <filter> 
               <value>Doors</value> 
               <value>Style</value> 
            </filter> 
         </subTypeQualifier> 
      </columnLookup>
      <columnI18NLookup languageCdUid="C_LU_AUTO_ATTR_LCL|LANGUAGE_CODE"            
         countryCdUid="C_LU_AUTO_ATTR_LCL|COUNTRY_CODE" lookupFKUid="C_LU_AUTO_ATTR_LCL|CODE" 
         localizedNameUid="C_LU_AUTO_ATTR_LCL|LOCALIZED_STRING">
         <subTypeQualifier columnUid="C_LU_AUTO_ATTR_LCL|ATTR_TYPE " filterValue="Doors"/>
      </columnI18NLookup>                                              
   </column>

Rename Saved Search

Table of Contents

Data Director Implementation Guide

Data Director Implementation Guide

Lookup Tables With Subtype Column

Lookup Tables With Subtype Column