...
Item | Description |
|---|---|
 | Use the Add |
 | Use the Delete |
And | Logical operators display in Red text. Select a logical operator to display a menu of available logical operators:  |
[Column Value] | Column values display in Blue text inside square brackets. Select a column name to display a menu of available columns. |
Comparison Operator | Comparison operators display in Green text. Select an operator to display a menu of available operators:  |
Operand | Operand values display in Black text. Select an operand value to display a text box where you can change the value. |
Condition group | A filter condition group is a set of conditions combined by the same logical operator (And, for example). You select Add Group from the logical operator menu to add a new condition group.  |
Add a condition
To add a condition to a logical group, do one of the following:
...
Filter criteria typically consist of two or more simple filter conditions combined by logical operators (AND, OR, NOT AND, NOT OR). The following example shows how to construct filter criteria in the Filter Editor that consists of multiple conditions combined by a single logical operator (AND). The [Lot Number] starts with L- AND [Batch Quantity] >= 100,
AND [Batch Status] = On Hold. This filter expression contains three simple filter conditions combined by the AND operator.
...
Example 2: Filter criteria with multiple logical operators
...