Working with Database Operations > Using the Database Operation File Editor > Predicate Tab > Setting Conditions for a Simple Database Operation
	Setting Conditions for a Simple Database Operation

A Simple condition sets a single condition that affects 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 Simple condition to return information for only those customers who have opened accounts in the past 30 days.

In a case like this, you would set up the condition to look 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.

If you need to use two conditions for a single database operation, use the Compound condition setting. See Setting Conditions for a Compound Database Operation.

To set the conditions for a simple database operation:

1. From the palette, under Condition, select Simple and place it in the workspace.

2. From the palette, under Operand, select Column and place it in the workspace.

3. In the workspace, select the Column operand you just placed there, and then, in the Avaya Properties view, Name field, select the column to use in testing the condition.

4. From the palette, under Operator, select Comparison and place it in the workspace.

5. In the workspace, select the Comparison operator you just placed there, and then, in the Avaya Properties view, Operator field, select the operator to use in making the comparison between the column value and the variable or constant value.

6. From the palette, under Operand, select one of the following operands and place it in the workspace:

• Variable - To compare the column value with a variable value, use this option.

• Value - To compare the column value with a constant or absolute value, use this option.

7. In the Avaya Properties view, perform one of the following actions:

• If you selected Variable as the second Operand, select from the Name drop-down list the variable to use for the comparison.

• If the variable is a complex variable, you must also select a field from the Field drop-down list.

• If you selected Value as the second Operand, enter in the Value field the exact value to be used for the comparison.

Following is an example of a nested Simple condition. See example in Setting Conditions for a Compound Database Operation.

©2009, Avaya Inc. All rights reserved.