How do I filter the rows in a MainView for z/OS or MainView Infrastructure view?

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    MainView for z/OS


    COMPONENT:

    MainView for z/OS 6.2


    APPLIES TO:

    All MainView products



    QUESTION:

    How do I filter the rows in a MainView view? What are the different ways?


    ANSWER:

    There are several ways to filter data on a MainView view.

    1. INCLUDE MASK or INC MASK command
    This allows you to filter on each column of a view, you can also filter on multiple columns.
    For help on the syntax, type INCLUDE on the COMMAND  ===> line and press PF1

    An example can be found in Knowledge Article 000173413

    2. WHERE / QWHERE commands
    Similar to the INCLUDE MASK command, this allows you to filter on each column of a view, you can also filter on multiple columns.
    However, the WHERE / QWHERE commands allow you to include complex filters..
    For help on the syntax, type WHERE / QWHERE on the COMMAND  ===> line and press PF1

    Knowledge Article 000165788 has additional information on WHERE / QWHERE and field level filtering use implications.

    3. Customise the view to include a column filter that takes effect each time the view is invoked.
    - Enter CUST or CUSTOM on the view 
    - enter option L 'column id' and set the filter
    - save the view
    For help on the syntax, type CUSTOM on the COMMAND  ===> line and press PF1

    NOTE:
    In filtering options 1 and 2 described above, the filtering is lost once you exit MainView.
    In option 3, the filter is saved with the view and is applied each time you invoke the view.

    If you do not wish to modify (using CUSTOM) the view distributed with MainView, you have the option to set the WHERE / QWHERE filtering and then saving the screen using the SAVESCR command.
    The saved screen stores the view name(s) that are included in the screen as well as properties such as the WHERE / QWHERE filtering.
    The benefit is you do not need to modify the view distributed by BMC and 're-fit' the fitering changes with future upgrades of MainView.

    See help (ie: COMMAND  ===> line and press PF1) on SAVESCR and SCREENS for further information and use.

     


    Article Number:

    000175934


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles