Filtering the History Rows
You can sort and filter the History rows is various ways to help organize the information.
History Filter Operators
All history rows are now stored in a single History database. The History Filter dialog box allows you to specify a set of filters to be applied to the history rows. The operators include >, <, =, and LIKE. The filter applies to the entire history table. When you click in the fields or boxes in the Filter dialog box, the possible operators and proper format appear at the bottom of the dialog box.
Note: The operator box accepts only applicable operators for the filter function.
To filter the History table
1 Select the History window.
2 Right-click in the History window and select Filter.
3 Set the history filter as needed. Table 30 explains the History filter options.
History Filter Option |
Description |
Date |
Filters by date range. Clicking the combo box brings up a calendar. Place a filter operator (>, <, =,) in the operator box. To display the history for the most recent n days instead of basing it on a fixed date, select Previous ‘n’ days and enter the number of days in the date box. |
Data Source |
Filter by data source name. Enter a data source name, which can contain wildcard characters. Select Use current Data Source to filter by the current data source only. Note: The Use current Data Source filter option is used only when the Allow connection to multiple data sources option is not selected. See “Setting General Program Preferences” on page 55 for information about setting this option. |
User Name |
Shows only those rows for a specific User Name. |
SQL Text |
Shows only those rows matching the specified string in the SQL text column. Note: See “Using Wildcard Characters with the History Filter” on page 144 for more information on using valid wildcard characters with this option. |
Notes |
Shows only those rows matching the specified string in the Notes column. Note: See “Using Wildcard Characters with the History Filter” on page 144 to learn more about valid wildcard characters to use in this option. |
Statement Type |
Shows only those rows in which the query contains the specified statement type. For example, Select or Create Table. |
Statement Count |
Show only those rows in which the query contains this many statements (Use operator <, > or =). |
Row Count |
Shows only those rows in which the query effected this many rows (Use operator <, > or =). |
Elapse Time |
Shows only those rows in which the elapsed time matches the time entered (Use operator <, > or =, and specify the time as hh:mm:ss). |
Show successful queries only |
Select this box to filter for successful queries only. Queries with errors are ignored. |
Using Wildcard Characters with the History Filter
The following wildcard characters are acceptable to use with the history filter:
Wildcard matches are not case specific. To match the percentage character (%) by itself, enclose the character in brackets. For example, enter ‘%[%]%’ in the SQL Text field to return all rows containing a % sign in the SQL text.