Bookshelf Home | Contents | Index | Search | PDF

Siebel Life Sciences Guide > Information for Siebel Application Developers >

Controlling Query Behavior in Multi-Value Group Fields

---

In order to implement the Siebel Life Sciences Targeting functionality, the default behavior of queries in Multi-Value Group (MVG) fields has been changed. In this new MVG behavior, an EXISTS statement is automatically added to every query in Siebel Life Sciences. This allows detailed cross-business object queries in the Targeting view. For example:

Find all the Contacts
Who are ranked High in a specific therapeutic class
Who have not been visited for over a month by any sales representative
With a best time to call on Monday afternoon

This MVG behavior, however, also prevents the following query in an MVG field:

EXISTS (A) AND EXISTS (B).

To disable the EXISTS statement

From the application-level menu, choose View > Site Map > Application Administration > System Preferences.
Set the Default MVG Exists Query to FALSE.

Bookshelf Home | Contents | Index | Search | PDF