Default language.

Setting a simple filter for a data element in a view column


Use the following procedure to limit the data shown in a view column by setting simple filter conditions.

The filter will contain the following elements:

  • The internal letter assigned to the column (column ID)
  • An operator
  • A numeric or mask value

The view of the column changes according to the application of the filter criteria to the data elements. For example, the following procedure sets the conditions necessary to see a specific installation status in the Plex Manager TGTDEF view.

To set a simple filter

  1. On the view's COMMAND line, type CUST and press Enter.
  2. In the OPTION field, type L followed by the letter of the column to be filtered and press Enter.For this example, use E for the Install Status column:

    ------------------------ VIEW CUSTOMIZATION - TGTDEF --------------------------
    OPTION  ===> l e                                               SCROLL ===> HALF
    Options: (that require column selection)       Other options:
    F - Format    M - Move       I - Include       G - Graph      S - Save view
    O - Order     R - Repeat     X - Exclude       P - Parameters E - Show excluded
    L - Filter    T - Threshold  H - Hyperlink     Z - Summarize  K - Show template
    ---------------------< Filter  -   column: E   element: TGTDSTAT        >------
    Filter condition   =>
    Parameter position =>   (optional: 1 to 8; blank means not used positionally)
     A condition consists of the column id, an operator, and a value. This value
     can be overridden by requesting this view with a keyword parameter (using the
     element name as keyword) or a positional parameter (if you assign a position).
    -------------------------------------------------------------------------------
        A        B        C        D                                E
    CMD CAS      Target   Product  Description                      Install
    --- Name---- Name---- -------- ------------                     Status--
        SYSA     DB2P     MVVP     BBCS TEST DB2 V3                 Modified
        SYSA     ETCCIC4  MVCICS   EMPRISE TECH CICS V4.1           Not Installed
        SYSA     SSICICS  MVCICS   SPECIALIZED SOFTWARE V           Modified
        SYSA     ETCDLSOT MVCICS   EMPRISE TECH CICS V3.3           Not Installed
        SYSA     GUPCIC4  MVCICS   GUPTA CICS V4.10                 Not Installed
        SYSA     PUBCICS  MVCICS   BBCS PUBLIC CICS V2.12           Modified
        SYSA     PUBCIC3  MVCICS   BBCS PUBLIC CICS V3.30           Modified
        SYSA     ETCCICS  MVVP     EMPRISE TECH CICS V3.3           Modified

    Tip

    For additional information about using the L option, see the filtering information in the online Help.

  3. In the Filter condition field, type E = N* and press Enter.This filter requests only targets that have a status of Not Installed, as shown in this example:

     ----------------------- VIEW CUSTOMIZATION - TGTDEF --------------------------
     OPTION  ===> L                                                SCROLL ===> HALF
     Options: (that require column selection)       Other options:
     F - Format    M - Move       I - Include       G - Graph      S - Save view
     O - Order     R - Repeat     X - Exclude       P - Parameters E - Show excluded
     L - Filter    T - Threshold  H - Hyperlink     Z - Summarize  K - Show template
     ---------------------< Filter  -   column: E   element: TGTDSTAT        >------
     Filter condition   => E = N*
     Parameter position =>   (optional: 1 to 8; blank means not used positionally)
      A condition consists of the column id, an operator, and a value. This value
      can be overridden by requesting this view with a keyword parameter (using the
      element name as keyword) or a positional parameter (if you assign a position).
     -------------------------------------------------------------------------------
         A        B        C        D                                E
     CMD CAS      Target   Product  Product Description              Install
     --- Name---- Name---- -------- -------------------              Status--
         SYSA     ETCCIC4  MVCICS   EMPRISE TECH CICS V4.1           Not Installed
         SYSA     ETCCIC4  MVVP     EMPRISE TECH CICS V4.1           Not Installed
         SYSA     TERXCICS MVCICS   TENERA                           Not Installed
         SYSA     ETCDLSOT MVCICS   EMPRISE TECH CICS V3.3           Not Installed
         SYSA     GUPCIC4  MVCICS   GUPTA CICS V4.10                 Not Installed
         SYSA     ETCDLSOT MVVP     EMPRISE TECH CICS V3.3           Not Installed
         SYSA     GUPCIC4  MVVP     GUPTA CICS V4.10                 Not Installed
         SYSA     IMSCTL   MVVP     IMS                              Not Installed
  4. When finished, press the END (PF3) key.
  5. In the Save changes field, type YES.
  6. When prompted for the following information about the new view, complete each field and press Enter:

    • View name
    • Replace
    • Description
    • Dynamic fields
    • Summary view
    • Threshold Location

    For descriptions of these fields, see the online Help.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*