Bookshelf Home | Contents | Index | Search | PDF |
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 42.
Assume two picklists are configured to display the values shown in Table 42 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
- Configure a parent and a child picklist.
- Go to the business component that contains the fields that you want to associate the hierarchical picklists with.
- Compile changes to a repository file.
- Add LOV values using the Parent LIC column to designate the parent value.
See table above for a simple example and see the Constrained Lists of Values section in Applications Administration Guide for detailed discussion.
- Test.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Tools Reference Published: 20 October 2003 |