Filters can be applied to Problems, SQL Log, and the SQL Errors views to limit searches when troubleshooting and pinpointing specific processes within the system.
To filter the SQL Log
To view and filter the Problems log
The ability to define different profiles enables the selection of multiple filter profiles. For each profile selected, the profile criterion is applied to the View, concurrently. You can filter problems by:
Profile Criteria | Description |
---|---|
Working Set | The options located in the Scope area of the dialog enable you to filter problems based on defined Working Sets. A Working Set is a collection of user-defined Project files that you can organize, as needed, in SQL Query Tuner. Select an option, and then click Select to define a Working Set to which the parameters apply. If no Working Sets exist, you need to define one or more via the New button on the Select Working Set dialog. Select one or more Working Sets to which you want the criteria to apply. If no Working Sets exist, or none suitably match the current filter criteria, click New or Edit to define a new Working Set, or edit an exist Working Set, respectively. |
Character String | Use the Description list to select contains or doesn't contain, as needed, and type the character string in the field below the list. The Problems view is filtered to only contain, or omit, problem descriptions that fully or partially match the string value. |
Problem Severity | In the Where severity is area, choose Error, Warning, Info or some combination of the three check boxes. Only entries whose severity matches the check boxes you have selected remain visible in the Problems view. |
Problem Type | The options in the Types list on the right-hand side of the dialog enable you to filter problems by type. For example, deselect Problem to remove any system entries from the view, or deselect SQL Error Marker to remove any SQL code entries from the view. |
Once you have defined and/or selected the appropriate filter profiles, the profiles will appear in the Show submenu in the Toolbar Menu of the Problems view. Select or deselect the profiles from the submenu, as needed.
| | | | | | | |