- Right-click in the History window and select Filter.
-
Set the history filter fields.
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 then 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.
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 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.
See Using Wildcard Characters with the History Filter for more information on using valid wildcard characters with this option.
Notes Shows only those rows matching the specified string in the Notes column.
See Using Wildcard Characters with the History Filter 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 =, then 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.