After configuring a table for the type of rule or data source 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, select 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. - Select Criterion.
- To filter by field:
- Click Select a field and select a field.
- Select an operator.
- Enter a value or select
to select a field to compare or create a formula to compare.
- To filter by formula:
- Select > Formula.
- Complete the Formula Builder fields.
- Select Save and Close.
- Select an operator.
- Enter a value or select to select a field to compare, or create a formula to compare.
- Select
GROUP Define an advanced filter with nested criteria. - Select 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.- Select Criterion.
- Complete the Formula Builder fields.
- Select Save and Close.
- Select an operator.
- Enter a value or select to select a field to compare, or create a formula to compare.
GROUP Define an advanced filter with nested criteria. - Select 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. - Select Continue.