Filtering the result set for an SQL app

Use the Filters dialog to limit the rows displayed from the result set shown in the SQL Errors and SQL Analysis applications. You can enter filters in one or more fields. If you enter values in multiple rows, the Filter dialog displays rows where all entered values match the contents of the row. You can use either the asterisk (*) or percent sign (%) as wildcard characters. Use the following procedure to filter the rows displayed for the SQL Errors or SQL Analysis applications.

To filter the result set

Click Filter .
The Filters dialog is displayed.
(Optional) Click Clear to empty all the fields in the dialog.

Enter values in one or more of the fields listed in the following table

Field	SQL Errors	SQL Analysis
Plan	x	x
Program	x	x
User	x	x (SPE2010)
Client Application (SPE2010)	x	x

You can use the asterisk (*) or percent sign (%) wildcards as the last character in a field.

Select one of the following actions:
1. Click OK to save your changes.
  Workbench refreshes the rows displayed in the application and lists the filter values entered in the dialog at the top of the page.
2. Click Cancel to return to the application without saving your changes.

Related topic

Troubleshooting SQL statements

Filtering the result set for an SQL app

To filter the result set

Comments