SQL Sentry Condition Filter

SQL Sentry allows you to build complex filters for the purposes of History Filtering and defining Conditionsettings. This topic covers the functionality of the Condition Filter that's common to History Filtering and Condition Settings.

Condition Filter Overview

The following diagram identifies the various aspects of the Condition Filter.

Condition Filter Rules

When using the ConditionFilter, build criteria that an event must meet by defining rules. 

Each filter rule is made up of three distinct parts:

Option	Description
Column Name	Defines the scope of the rule.
Operator	(Criteria operator) defines an instruction for testing the value (operand value).
Value	(Operand value) for this filter rule.

Rule Groups

Individual rules are logically grouped into rule groups. Each group contains a logical operator that defines how the rules are combined within the group. Each group uses the And logical operator. When a group is created with the And logical operator, each filter rule that's part of the group must be true for the group to evaluate as true. Change the logical operator defined for a group by selecting it; a drop-down menu appears, allowing you to choose an alternative (And, Or, NotAnd, NotOr).

Context Menus

When you select any logical operator, additional options are available from the drop-down menu:

Option	Description
Add Condition	Adds a new filter rule to the condition group.
Add Group	Creates a new sub-group beneath the existing group with the default And Logical operator.
Remove Group	Deletes the selected group.
Clear All	Available from the root logical operator; deletes all filter rules.

Selecting the plus + symbol next to any group's Logical operator adds a new filter rule to the group. Selecting the x symbol next to any filter rule deletes that rule from the group.