Adding a filter

Add a filter to refine your view of the data displayed in the Activity Browser data table.

Procedure

  1. From any window within the CAE browser client, click Application Menu > Filters > Manage.
  2. Click Add.
  3. Type a filter name in the Filter Name field.
  4. Specify the following options:
    • Select the Mixed Case checkbox to apply the filter to mixed case characters.
    • Select the Match Case checkbox to apply the filter to characters that match the filter case.
    • Select the Exclude checkbox to exclude any activity that matches the filter.
    Mixed Case and Match Case behave as follows:
    • Mixed Case (selected) and Match Case (not selected) - Filter values are stored as entered but filter values and field values are treated as upper case for comparison.
    • Mixed Case (selected) and Match Case (selected) - Filter values are stored as entered but filter values and filed values are compared as is.
    • Mixed Case (not selected) and Match Case (not selected) - Filter values are upper cased when stored and field values are treated as upper case for comparison.
    • Mixed Case (not selected) and Match Case (selected) - Filter values are upper cased when stored and comparison are made to field values, as is.
  5. Specify how to handle AND/OR between columns.
  6. Specify how to handle AND/OR within columns.
  7. Click Add Row.
  8. From the Column list, select the column for which you want to create a filter line.
  9. From the Operator list, select the operator you want to use in the filter line.
  10. In the Value field, type the value you want to use in the filter line.
    You can use the Remove Row button to remove rows you do not want to include in your filter. Db2 Query Monitor evaluates data based on the Column, Value, and Operator you specify in each filter line. If a match occurs, then the data are filtered according to the Exclude check box status. If the Exclude check box is selected, data are excluded from display when a match occurs. If the Exclude check box is not selected, data are included from display when a match occurs (and data that do not produce a match are excluded from display).
  11. Click Save.