Writing a freeform filter

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

  1. Click in the Data filters tool in the toolbar of the Sheet view.
  2. 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*

  3. Optional: Use the functions in the Data filters tool to create a filter.
    1. To see a list of all the fields that can be used in a filter, press Ctrl+Space.
      Freeform filter tool
    2. To select the required field, double-click it.
    3. Press Ctrl+space again and select the required operator from the list.
    4. Type an appropriate value to complete the filter.
  4. To add more fields and values to the filter, type directly or press Ctrl+space and select from the list.
  5. To run the filter, click the Apply filter icon Apply filter icon.
  6. To save the filter with the layout, click the View Menu icon 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.