|
|
|
|
|
| Working with Database Operations > Using the Database Operation File Editor > Predicate Tab > Setting Conditions for a Compound Database Operation | |
 |
Setting Conditions for a Compound Database Operation |
A Compound condition sets two conditions that both affect the operation.
For example, suppose you want the database operation to return the names of customers who opened accounts within the past 30 days. You have already set up the database operation file to return the names of customers, but you want to use a Compound condition to return information for only those customers who have opened accounts in the past 30 days and who have an outstanding balance of more than $500.
In a case like this, you would set up a Compound condition with two Simple conditions: The first Simple condition looks at the column containing the date the account was opened, and return only those records for which the date is 30 days or less from the current date. The second Simple condition looks at the current balance column and returns only those customers from the first set of returns that have an outstanding balance of more than $500. The final returns from this operation would contain the names of only those customers who meet both conditions.
Each Compound condition permits you to set two and only two conditions. However, if you need to set more than two conditions, you can nest Simple and Compound conditions within other Compound conditions to attain the number and combination of conditions you need.
If you want to use only a single condition for a database operation, use the Simple condition setting. See Setting Conditions for a Simple Database Operation.
To set the conditions for a compound database operation:
Following is an example of a Compound condition.
Example of a Compound Condition
|
|
©2009, Avaya Inc. All rights reserved.
|