Configuring Siebel eBusiness Applications > Configuring Picklists and Pick Applets >

About Hierarchical Picklists


A hierarchical picklist displays values that are constrained by values selected in another picklist. For example, in the Service Request Detail Applet, the Area and Subarea fields are both picklists that draw their values from the List of values table (S_LST_OF_VAL). The items available in the Subarea picklist depend on what the user has selected in the Area picklist.

The hierarchical relationship between the values is established in the list of values table. All the values for picklists within the hierarchy are defined using the same LOV Type. For example, for Area and Subarea, the values are defined using the SR_AREA LOV Type.

The Parent Independent Code column is used to specify a parent value. For example, consider the following example LOV shown in Table 51.

Table 51.  Sample LOVs for Hierarchical Picklist
Type
DIsplay Value
Language Independent Code
Parent LIC

SAMPLE_LOV

1

1

 

SAMPLE_LOV

A

A

1

SAMPLE_LOV

B

B

1

SAMPLE_LOV

2

2

 

SAMPLE_LOV

C

C

2

SAMPLE_LOV

D

D

2

Assume two picklists are configured to display the values shown in Table 51 in a hierarchical relationship. One picklist is the parent picklist, and the other picklist is the child. The parent picklist displays the values {1, 2}. If the user selects 1, the values displayed in the child picklist are {A, B}; If the user selects 2, the values displayed in the child picklist are {C, D}.

Implementing a hierarchical list of values also involves configuration work. You must configure two picklists to support this hierarchical relationship. The parent picklist must be based on the PickList Hierarchical business component, and the child picklist must be based on the PickList Hierarchical Sub-Area business component.

Configuring Siebel eBusiness Applications