Siebel Tools Reference > Pick Applets and Static Picklists > Static Picklists >

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 48.

Table 48. 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 48 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.

To implement a hierarchical picklist

  1. Configure a parent and a child picklist.
    1. Set the Business Component property of the parent picklist to Picklist Hierarchical.
    2. Set the Business Component property of the child picklist to Sub-Area Picklist Hierarchical.
  2. Go to the business component that contains the fields that you want to associate the hierarchical picklists with.
    1. Set the Picklist property of the parent field to the parent picklist.
    2. Set the PickList property of the child field to the child picklist.
    3. For the child field, create the following Pick Map objects.

      4. Field
      PickList Field
      Constrain
      [name of parent field]
      Parent
      TRUE
      [name of child field name]
      Value
       

  3. Compile changes to a repository file.
  4. Add LOV values using the Parent LIC column to designate the parent value.

    5. See table above for a simple example and see the Constrained Lists of Values section in Applications Administration Guide for detailed discussion.

  5. Test.

 Siebel Tools Reference, Version 7.5, Rev. A 
 Published: 18 April 2003