Developing and Deploying Siebel eBusiness Applications > Pick Lists, Drilldowns, and MVGs > Configuring Pick Lists >

Dynamic Pick Lists


Like static pick lists, dynamic pick lists allow the user to populate fields by selecting values from a list. However, rather than drawing the values from the list of values table, a dynamic pick list draws its values from another user-maintained business component. Fields that use dynamic pick lists are typically joined fields displaying data from a table other than the business component's base table. The dynamic pick list allows users to update the joined field.

NREC design includes a dynamic pick list on the Activity Detail Applet. The opportunity field that you exposed on the applet (see Adding the Opportunity Field to a Activity Detail Applet (SCW)) is a joined field. Creating a dynamic pick list on this field will allow users to update the activity record by pulling in the opportunity name from the Opportunity table.

The Pick List Wizard walks you through the process of creating a dynamic pick list and related objects, which include:

Before creating a dynamic pick list you must lock the projects for both the pick business component and the originating business component. For the current example lock the Action project locally and then change the value of the Project property to NREC Configuration. In previous chapters, you should already have associated the Opportunity business component with the NREC Configuration project, which should be locked.

To create a dynamic pick list

  1. Choose File > New Object.
  2. Under the General Tab, select the Pick List icon, and then click OK.
  3. In the Pick List dialog box, enter the following.
  4. Field
    Value
    Description
    Project
    Activity
    Project to which the pick list will belong.
    Business Component
    Action
    Business component in the project that contains the field for which you are defining the pick list.
    Field
    Opportunity
    Field for which you are defining the pick list.

  5. In the Pick List Type dialog box, select the Dynamic radio button.
  6. In the Pick List Definition dialog box, select the Create new Pick List radio button.
  7. In the next Pick List Definition dialog box, enter the following values and then click Next:
  8. Field
    Value
    Description
    Pick Business Component (business component you want to base the pick list on)
    Opportunity
    This is the business component from which you are drawing values to display to the user.
    Field to sort by
    Created
    Records are sorted by this field in the pick applet.
    Name
    Opportunity NREC
    Name of the Pick List.

  9. In the Pick List Specifications dialog box, accept the defaults; leave all of the check boxes unselected.
  10. In the Pick Map dialog box, use the drop-down lists to select the following and then click Add:
  11. Field in Originating BusComp
    Field in Pick BusComp
    Opportunity
    Opportunity

    This information is used to define the Pick Maps for the Pick List. They are the mappings between the source field and the target field.

  12. In the Finish dialog box, review the information you entered and then click Finish.
  13. The Pick List wizard creates the pick list, pick maps, and checks to see if a pick applet already exists that can be used to display the records. For the NREC example, there is already an Opportunity pick applet defined, so the New Applet Wizard does not open. If an appropriate pick applet did not exist, then the New Applet Wizard automatically opens.

  14. Compile and test.
  15. Be sure to compile the Activity project.

    Click for full size image


 Developing and Deploying Siebel eBusiness Applications 
 Published: 18 April 2003