Data Director Implementation Guide

10.3 HotFix 1
- 10.5 HotFix 3
- 10.5
- 10.4 HotFix 3
- 10.4 HotFix 2
- 10.4 HotFix 1
- 10.4
- 10.3 HotFix 3
- 10.3 HotFix 2
- 10.3

Back Next

Lookup Column

An IDD application automatically populates a drop-down list of acceptable values for columns that are configured in the Schema Manager as lookups.

This is handled in the IDD Configuration Manager for columns that have a foreign key to the lookup table. If the foreign key does not exist (for example, for performance reasons), the information about the lookup table can be specified in the XML configuration.

An explicit lookup is defined using the columnLookup element, as shown in the following example.

<column columnUid="C_PARTY|GENDER_CD" editStyle="FIELD" horizontalStyle="SMALL">
      <columnLookup lookupFKUid="C_LU_GENDER|GENDER_CODE" 
          lookupNameUid="C_LU_GENDER|GENDER_DISP"/>
   </column>

In this example, column C_PARTY|GENDER_CD should be treated as if it has a foreign key to the column C_LU_GENDER|GENDER_CODE, and table C_LU_GENDER is treated as a lookup table. The IDD application creates a drop-down list for the column GENDER_CD, and this list is populated with values from the table C_LU_GENDER (display values are retrieved from the GENDER_DISP column).

Element columnI18NLookup can be specified together with sub-element columnLookup if the localization of display values is needed.

<column columnUid="C_PARTY|GENDER_CD" editStyle="FIELD" horizontalStyle="SMALL">
      <columnLookup lookupFKUid="C_LU_GENDER|GENDER_CODE" 
         lookupNameUid="C_LU_GENDER|GENDER_DISP"/>
      <columnI18NLookup languageCdUid="C_LU_GENDER_LCL|LANGUAGE_CODE"
         countryCdUid="C_LU_GENDER_LCL|COUNTRY_CODE"
         lookupFKUid="C_LU_GENDER_LCL|GENDER_CODE"
         localizedNameUid="C_LU_GENDER_LCL|LOCALIZED_STRING"/>
   </column>

Subject Area

Lookup Tables With Subtype Column

Static Lookup Values

Lookup Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal