This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
MainView for z/OS
MainView for z/OS 6.2
All MainView products
How do I filter the rows in a MainView view? What are the different ways?
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
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.