Concepts

Tasks

Settings

Working With Selection Criteria

You can add as many filter criteria to a purging rule as needed, and you can use filter groups to specify which criteria are evaluated together. Logical operators (AND and OR) are used to define the relationships within and between filter groups.

The Selection Criteria tab allows you to work with a purging rule’s criteria in several ways. You can:

•	View the selection criteria in one statement

•	Change the relationships within and between filter groups

•	View the SQL select statement for the selection criteria

Viewing the Selection Criteria

The top area on the Selection Criteria tab displays the full statement used to select the objects to be purged. For example:

In this example, two filter criteria belong to group 0:

•	Acknowledgment status is “Acknowledged”

•	Indicator was collected more than two years ago

Group 1 contains one criterion: the indicator asset is 2000.

The criteria in group 0 use the AND operator to specify that an indicator reading must be older than two years and be acknowledged to be purged. The relationship between the filter groups is OR, which means that indicator readings that do not meet group 0’s criteria are still purged if they are for asset 2000.

For more information about filtering concepts, see Selection Criteria Concepts for Purging Rules.

Changing the Relationship Between Filter Groups

Boolean logic allows you to define the relationship between filter groups. In Boolean searching, an AND operator between two criteria (for example, Title contains “pear” AND “apple”) returns records where the Title contains both values, not just one of them. An OR operator between two criteria (for example, Title contains “pear” OR “apple”) returns records that contain either of the words.

The default choice is ANDed within a group, ORed between groups. Because each group typically contains only criteria for the same attribute, in most situations it is not necessary to change the default operator.

For example, the following criteria and the ANDed within a group, ORed between groups setting:

Group	Criteria
0	A = 3
1	A = 7
2	B > 11
2	B < 21

are evaluated as: A=3 OR A=7 OR (B>11 AND B<21).

If the logical operator setting is changed to ORed within a group, ANDed between groups and the groups the criteria belong to:

Group	Criteria
0	A = 3
0	A = 7
1	B > 11
1	B < 21

the set is now evaluated as: A=3 OR A=7 AND (B>11 OR B<21).

To Change the Relationship Between Filter Groups

1.	Open the purging rule. The purging rule’s activation status must be “Suspended” before you can make changes to it.

2.	Select the Selection Criteria tab.

3.	Select the criteria relationship:

•	ANDed within a group, ORed between groups: an object must comply with all criteria in a group for it to be selected; an object that is selected by any group is purged.

•	ORed within a group, ANDed between groups: an object that complies with any criterion in a group is selected; an object must comply with at least one criterion in each group to be selected.

4.	Click OK to save the change and close the Purging Rule dialog.

Previewing the SQL Select Statement

When a purging rule is executed, the selection criteria is translated into an SQL select statement. You can preview the SQL to be produced by clicking View SQL. You cannot alter the generated SQL.

Tip: You can view a list of the objects that would be selected by the purging rule’s criteria by clicking Preview.