Creating Variable Filters
You can create private and global filters to search for specific variables. When creating a new filter, you must use a unique name
To create variable filters:
- In the Navigation pane, click Variables.
- In the Navigation pane, click the Filters tab.
- Right-click in the tab and select New.
The New Filter (Variable) dialog opens.
-
In the Name text field, enter a unique name.
Filter names have a maximum of 100 characters. Special characters are allowed, and you can include numbers in your filter names.
-
In the Description text field, enter a description identifying the filter.
Descriptions have a maximum of 256 characters. Special characters are allowed, and you can include numbers in descriptions.
-
To add attributes and columns to the Filters pane, double-click on the attribute or column in the Navigation tree or use the drag-and-drop operation.
When using the drag-and-drop method, you will need to place the attribute or column on the Filters tree.
-
To change the condition, use the Filter toolbar.
Condition
Button
Description
AND
All conditions must be met.
OR
One of two conditions must be met.
AND <> OR
Toggle between the AND OR conditions.
Remove
Delete the filter or condition once selected in the Where Criteria portion of this dialog.
- Select an attribute or column that you want to add new values.
- Select Static Filter or Dynamic Filter.
Static filters are fixed, and dynamic filters are not fixed. If you choose a static filter, then you need to specify an operator and an operand. If you choose a dynamic filter, then you are prompted for the operator at runtime.
-
Select an Operator.
The operators in the list are determined by the data type.
Operator
Description
=
Equal to
>
Greater than
<
Less than
>=
Greater than or equal to
<=
Less than or equal to
<>
And/or
LIKE
Similar to
NOT LIKE
Not similar to
- Select the Not check box if you want to reverse the filter.
- Based on the filter you choose, enter an Operand value for a static filter or a Prompt value for a dynamic filter.
-
Click OK.
The new filter is saved as a private filter and appears in the Filters tab.
To create a global filter, right-click on the filter and select Private to remove the check mark.
To edit a variable filter:
- In the Navigation pane, click Variables.
- In the Navigation tree, click the Filters tab.
-
Right-click on a filter and select Edit.
The Edit Filter (Variable) dialog opens.
- Repeat the steps in the process above, as needed.
- Click OK to save your changes.