Compound Query Operators

A compound query is a type of query that locates records according to more than one condition. You can use parentheses to control the order that Siebel uses to execute a compound query. Siebel runs the query according to the expression that you enter. It starts with the inside parentheses and then proceeds to the next, similar to the order in which you read English.

The following table describes operators that you can use for a compound query. You can combine simple conditions and compound conditions in a single query. For more information, see Siebel Developer's Reference.

Operator	Description
AND	All the conditions that the AND operator connects must be true.
OR	At least one of the conditions that the OR operator connects must be true.
NOT	The condition that the NOT operator precedes must be false.

To use a compound query, do one of the following:

• Enter conditions in two or more properties.

• When you run the query, Siebel uses an AND operator between the conditions that you enter.

• Use OR, AND, and NOT operators in a single property.