Filtering

Columns in a summary subpanel may be designated as eligible for filtering. Some of these columns may have predefined filters. You can view a list of all the eligible columns and existing filters. You can add, modify, or remove filters for any column in the list. Only the columns in the first summary panel in a workspace can be filtered. Columns that are eligible for filtering are denoted with a green icon:

Columns that are eligible for filtering
Columns that have a filter in effect are denoted with a yellow icon:
Columns that have a filter in effect

You can view the list of filter-eligible columns by pressing PF4, entering the FILTER command or clicking on the filter icon within the column header. The list of columns is displayed in a popup panel:
List of column names with filter expressions
To enable, modify, or disable a filter:
  1. Enter the number of the filter you want to modify.
    A popup menu is displayed with the details of the filter definition:
    Filter Detail popup with static Column field and modifiable Compare and Value fields
    Use UCTRAN to specify whether the uppercase translation option is to be set (Yes), or if the value is to be used as it is typed in (No). The UCTRAN option can be used to filter lower or mixed-case values. The default is Yes.
  2. Take one of the following actions:
    • To add a filter, type the appropriate Compare operator and overtype N/A with the desired value, then press Enter.
    • To modify a filter, type the appropriate operator and value, then press Enter.
    • To remove a filter, erase either the operator or the value in the existing expression, then press Enter.

    If you press Enter, the filter list is redisplayed.

The following comparators are supported:
  • = or EQ (equal to)
  • <> or NE (not equal to)
  • > or GT (greater than)
  • < or LT (less than)
  • >= or GE (greater than or equal to)
  • <= or LE (less than or equal to)
The Value field supports strings or numbers. A trailing asterisk wildcard is supported, but not a leading asterisk. For example, C* but not *C. To indicate that a number is a substring rather than an integer, enclose the value in quotation marks. For example, in the preceding screen, specifying the value as 1234 displays all CICS regions whose names begin with the substring 1234.
If no columns have been designated as eligible for filtering, you will see the following message after you enter the FILTER command or press F4:
Message popup containing the text "This workspace has no filters defined"