Defining a table filter

Complete these steps to filter a custom table by text or timestamp attribute values. Although numeric values are not available for filtering, such as percentages, some numeric attribute values are converted to a display value for the table and treated as text.

1. After you open the Application Performance Dashboard from the Performance menu, drill down to an instance of the managed resource.
2. Click the Attribute Details tab.
   The most recently saved page is displayed or, if no pages have been saved, the Data Set and Attributes selection lists are displayed.
3. If a saved table page is displayed, continue to step 5, select another saved table page from the drop-down menu , or click Add to create a new table.
4. If you are creating a new table or editing a saved table, select the Data Set and Attributes to use, and click Preview Results.
5. For a quick filter, click in the Filter text box and type the partial or full text to filter by.
   As you type, any rows that do not contain what you typed are removed from the table. To remove the quick filter, delete the value or click the x.
6. For an advanced filter, click the drop-down menu and select Build Filter or click anywhere in the filter bar.
   The Build Filter window opens with any rules that were defined.

   
7. To define a rule, complete the fields:
   1. Leave the column setting at Any Column or select the attribute to filter by from the list.
   2. Leave the condition at contains or select another operator from the list and enter the text or timestamp value to filter by in the text box:

      Condition	Row is included in the table when...
      contains	the filter value is found somewhere in the cell.
      equals	the cell value matches the filter value exactly, including letter casing.
      starts with	the cell value begins with the same characters as the filter value.
      ends with	the cell value has the same characters at the end as the filter value.
      does not equal	the cell value is not an exact match of the filter value.
      does not contain	the cell value does not include the same text or number as the filter value.
      does not start with	the cell value does not begin with the same characters as the filter value.
      does not end with	the cell value does not end with the same characters as the filter value.
      is empty	the cell shows no data.

   3. After you complete the rule, click Filter to see the results, click Add Filter Rule to add another rule, or go to the next step.
8. If the filter has multiple rules, take any of these steps:
   • Match is initially set to All rules, which means that a row is displayed only if the data in the row follows all the rules in the filter. The row is excluded if no text or timestamp values follow any one rule. If you have multiple rules and you want a row included if it follows any of the rules, change the setting to Any rule.
   • To edit a rule, change any of the field values.
   • To delete a rule, select it and click Remove Rule.
9. When you are finished defining a rule (or rules), click Filter to close the dialog box and apply the filter.