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 |
Siebel Life Sciences Guide Published: 18 April 2003 |