Filter Table Records

The Filter Dialog enables you to control what data appears in a view.

Contents:


Use Quick Filtering

Quick Filtering enables you to view monitor profiles quickly and easily. You can apply filters across one or many of the columns in the Monitor Profiles table. Quick filtering uses a layered approach that enables you to combine filters. Filter combinations use the logic AND. For information about the available operators and wildcards, see Rules for Setting Filters .

You can use Quick Filtering in the Monitor Profiles table only.

Follow these steps:

  1. Type your filter term in the Quick Filter box.
    Your filter term is validated and is applied dynamically across the available columns. To refine your filter term, continue typing. The drop down list automatically suggests valid columns that do not already have a filter applied.

    Note: To control what columns are visible in the table, right-click the table and select Customize Table.

  2. To apply your filter term to a column, select the column from the drop-down list.
    The table is filtered in the specified column and your filter appears under the Quick Filter box.

  3. (Optional) To add a filter, type another filter term and apply it to a column.

  4. To remove a filter, click Clear. To remove all filters, click Clear All Filters.

Example:

To view all active monitor profiles that contain the text string "TEST" in the job name and were run at least 5 times during October 2015, create the following filters:

Status: active
Jobname: *TEST
Runs: >4
Date: 2015/10/*

Use Advanced Filtering

Advanced Filtering enables you to set multiple filter values at once. For information about the available operators and wildcards, see Rules for Setting Filters .

You can use Advanced Filtering on all the tables in the GUI.

Follow these steps:

  1. Right-click on a column header or one of the rows of data and select Filter Elements.
    The Configure Column Filter dialog appears.

  2. Type a filter term and any operators or wildcards in one or more of the fields.

  3. Click OK.
    The table refreshes to display only the records that match your filter terms.