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:

  1. In the Navigation pane, click Variables.
  2. In the Navigation pane, click the Filters tab.
  3. Right-click in the tab and select New.

The New Filter (Variable) dialog opens.

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  1. Select an attribute or column that you want to add new values.
  2. 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.

  1. 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

  1. Select the Not check box if you want to reverse the filter.
  2. Based on the filter you choose, enter an Operand value for a static filter or a Prompt value for a dynamic filter.
  3. 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:

  1. In the Navigation pane, click Variables.
  2. In the Navigation tree, click the Filters tab.
  3. Right-click on a filter and select Edit.

    The Edit Filter (Variable) dialog opens.

  4. Repeat the steps in the process above, as needed.
  5. Click OK to save your changes.

 

Related Topics Link IconRelated Topics