...
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:
...
To add a condition or group of conditions you copied to the Clipboard, press Ctrl+V or Shift+Insert. The new condition is added to the focused group.
Delete a condition
To delete a condition, do one of the following:
...
To remove a condition/group of conditions to the Clipboard, focus the condition or the group's logical operator, then press Ctrl+X or Shift+Delete.
Use the clipboard
To copy a condition or a group of conditions to the clipboard, focus this condition or the group's logical operator, then press Ctrl+C or Ctrl+Insert.
To cut a condition or a group of conditions to the clipboard, focus this condition or the group's logical operator, then press Ctrl+X or Shift+Delete.
To paste a condition or a group of conditions from the clipboard to the focused group, press Ctrl+V or Shift+Insert.
Change a column in a filter condition
To change a condition's column, do one of the following:
...
Select the required column from the list.
Change an operator in a filter condition
To change a condition's operator, do one of the following:
...
Select the required operator from the list.
Edit the value of a condition
To edit a condition's value, select the operand value and enter text.
To activate the operand value's edit box without changing the value, select the value or focus the operand value via the keyboard and press F2, Space, Enter, or Alt+Down Arrow.
To close the active edit box, press Enter.
To discard changes to the value and close the active edit box, press Esc.
Navigation
To focus a specific filter condition or a group's operator in the Filter Editor, do one of the following:
Select the target element.
Use arrow keys to move focus using your keyboard.
Example 1: Filter criteria with a single logical operator
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
Some filter criteria contain multiple logical (Boolean) operators combining simple filter conditions. For example, you want to see only Non-Serialized batches with an Active status and at the same time, you also want to see Non-Serialized batches with a status of On Hold. In this example, you use the AND operator for the first condition and the OR operator in a separate group to set up the second condition. The resulting condition would look like this in the Filter Editor:
...