Pick Applet Usage in Query Mode

If a pick map operates in query mode, then the fields that Siebel CRM copies includes the source field that the following items use:

  • The list

  • Any other list field that is part of the primary key

The source field is the business component field that the Business Component property of the list defines. Siebel CRM uses multiple fields for the query, so it is not possible to only copy back a single field.

For example, assume the user does a query through the list that Siebel CRM displays for the Parent Account Name field of the account list in the Account screen. Siebel CRM uses the name and location for the query because these fields are part of the U1 index of the underlying S_ORG_EXT table. The Location field is a primary key field for the Account business component and Siebel CRM includes it in the query.

You can define a pick applet so that Siebel CRM correctly enters data into the Subarea field according to the choice that the user makes, such as the Area field of the Service Request Detail Applet. You can use this configuration in edit mode but not in query mode. For more information, see Options to Control How the User Creates, Edits, Queries, and Deletes CRM Data and Creating a Hierarchical List.