Monday, October 10, 2011

Hierarchical PickList Configuration Step-by-Step!!

 

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.



Hierarchical PickList creation involves of using “PickList Hierarchical” Business Component as the BC for the PickList.

Step 1. :
Create for two LOVs: Here for my example I made the LOVs as SAMPLE_LOV_P acts for the Parent and SAMPLE_LOV for child.

TYPE; Display Value; Language-Independent Code; Parent LIC

SAMPLE_LOV_P 1 1

SAMPLE_LOV_P 2 2

SAMPLE_LOV A A 1

SAMPLE_LOV B B 1

SAMPLE_LOV C C 2

SAMPLE_LOV D D 2



Step 2:
Create two bound PickLists using SAMPLE_LOV_P for Parent and SAMPLE_LOV for Child, pick “PickList Hierarchical” for Business component.

Step 3:
Create two Fields named: Parent Field and Child Field

Modify their Pickmaps as follows:
Parent Field > Pickmap
FIELD :Parent Field PICKLIST FIELD:Value
FIELD :Child Field PICKLIST FIELD: Dummy


 Child Field > Pickmap
 FIELD : Parent Field CONSTRAIN: True PICKLIST FIELD  : Parent

 FIELD : Child Field PICKLIST FIELD : Value
Step 4:
Populate your Fields say “Parent” and “Child” on UI and compile.
Check the results which shows Two Parents 1 and 2 here in our example and
Children {A, B} for Parent 1 and Children {C, D} for Parent 2.
We have now Child Hierarchical PickList which is constrained on Parent Field Value.

Hope this is helpful!!!

Followers

Search This Blog