IDO Data Rule Filter Conditions tab

The Filter Conditions define the data conditions that must be met by an individual data row for a rule to be activated. 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 an IDO Data Rule Activation Conditions, the IDO must be checked out.

You can access the IDO Data Rule Filter Conditions tab from the IDOs form through the Data Rules button. The IDO Data Rule Filter Conditions is a subcollection grid and the Data Rule on the form is the primary collection.

You can create new rows in the grid by clicking any editable column in the grid and right-clicking on the column heading to see the operations you can perform, such as New, Delete, etc.

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: You can be leave this field blank when entering a value for comparison. Unlike some database queries, comparisons against a NULL value return no results (column > NULL or column < NULL). You can compare Greater than blank or Less than blank by leaving the Value cell empty. Records are evaluated and filtered based on the comparison.
And With Next Condition	Specifies whether this condition is logically combined with the next condition using `AND` or `OR` logic.