1. Object Types Reference
  2. Configuring Query For the Find Dialog Box

Configuring Query For the Find Dialog Box

The configuration of the Find dialog box and the configuration of a query by example might be different for a multivalue field. The Find dialog box uses the same query that an EXISTS query on a field in a query by example uses. To verify this configuration, you can use an Exists expression in the query by example. For example: 

Exists (Aga*)

Query by example supports each type of querying, but to keep the Find dialog box simple, Siebel CRM uses a query that works in all situations. If your implementation must not use the EXISTS configuration in the Find dialog box, then you can do the following:

  1. Create a join from the primary ID field for the multivalue link to the table that contains the data.

  2. Add a field on the table that you joined in the preceding instructions.

  3. Configure the find field to reference the field you added in the preceding instructions.