IDO Data Rule Filter Conditions tab

The Filter Conditions define the data conditions that must be met by an individual data row for it to be included in Data Rule processing for a given rule. Filter conditions are evaluated for each data row in an IDO request.

Each filter condition compares IDO property values using a standard comparison logic and can be combined with other conditions to form a complex expression.

Note: To make changes to IDO Data Rule Filter Conditions, the IDO must be checked out.

The IDO Data Rule Filter Conditions tab may be accessed from the IDOs form through the Data Rules button. The IDO Data Rule Filter Conditions are stored in a subcollection grid and the Data Rule on the form is the Primary collection data.

Create or delete rows in the grid by clicking in a cell of any editable column in the grid and then right-clicking on the column heading to see the available row operations.

In the IDO Data Rules form, the Filter Conditions tab show this grid:


Field	Description
Sequence	Determines the order in which filter conditions are evaluated.
Property Name	The IDO property whose value is evaluated by the condition.
Operator	Defines how the property value is evaluated. The supported operators include standard comparison operators, `Is Modified` and `Is Not Modified`.
Value Type	Specifies whether the comparison value is a literal value or another IDO property.
Value	The value used for comparison. This can be a literal value or the name of an IDO property, based on selected Value Type. Note: This field may be left blank while creating a condition and entering a value for comparison. Unlike some database queries where comparisons against a NULL value return no results (column > NULL or column < NULL), comparisons of Data Rule properties with a blank or NULL value behave differently. With Data Rules, it is possible to compare with condition: greater than blank or less than blank by leaving the Value cell empty. Records are evaluated and filtered based on the comparison and may return rows for consideration by the rule when using blank or a NULL for the value.
And With Next Condition	Specifies whether this condition is logically combined with the next condition using `AND` or `OR` logic.