You can write you own filter to select which records are
displayed in the Sheet view by using the Data
filters tool in the toolbar of the Sheet view.
About this task
Your filter must be suitable for the type of data in a column.
For example, if a column contains alphanumeric data, you can apply
a text filter, but you cannot apply a numeric filter.
Procedure
- Click in the Data filters tool in
the toolbar of the Sheet view.
- Optional: Type your freeform filter directly
into this field. For example, if you type the following
expression, only transactions that do not begin with the letter C,
that is, non-CICS® transactions,
are displayed:
transaction ID != C*
- Optional: Use the functions in the Data
filters tool to create a filter.
- To see a list of all the fields that can be used in
a filter, press Ctrl+Space.
- To select the required field, double-click it.
- Press Ctrl+space again and select the required operator
from the list.
- Type an appropriate value to complete the filter.
- To add more fields and values to the filter, type directly
or press Ctrl+space and select from the list.
- To run the filter, click the Apply filter icon
.
- To save the filter with the layout, click the View Menu
icon
in the toolbar of the view, then click Save Layout
As. In the Save Layout As dialog, enter a name and select
the Include current filter check box.