After configuring a table for the type of rule you are creating, set up WHERE and HAVING conditions. By default, all rows in the source tables selected are included. Adding filters constrains the rows to meet your defined criteria.
-
From Filter, click one of the tabs to apply a condition:
Condition Description WHERE Condition applied on a row-by-row basis.
Example: customer.age > 18
HAVING Condition applied to aggregate values.
Example: HAVING SUM(account balance) > 10000
-
Do the following to define the filtering output:
Filtering Type Description WHERE CRITERION Define a single filter. - Click CRITERION.
- To filter by field:
- Click Select a field and select a field.
- Select an operator.
-
Enter a value or click
to select a field to compare or create a formula to compare.
- To filter by formula:
- Select
> Formula.
- Complete the Formula Builder fields.
- Click SAVE AND CLOSE.
- Select an operator.
- Enter a value or click to select a field to compare, or create a formula to compare.
- Select
GROUP Define an advanced filter with nested criteria. - Click GROUP.
- Select ALL or ANY.
- Insert a new CRITERION.
HAVING CRITERION You must include an aggregate function, such as, SUM, COUNT, AVG, MIN, or MAX.- Click CRITERION.
- Complete the Formula Builder fields.
- Click SAVE AND CLOSE.
- Select an operator.
- Enter a value or click to select a field to compare, or create a formula to compare.
GROUP Define an advanced filter with nested criteria. - Click GROUP.
- Select ALL or ANY.
- Insert a new CRITERION.
Tip:To delete a criterion or group, select
> Delete.To duplicate a criterion or group, select
> Duplicate. - Click CONTINUE.