Filtering the History Rows - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide
Product
SQL Assistant
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.

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.

 

Table 30: Description of History Window 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 54 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 142 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 142 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:

  • ‘%’ matches zero or more characters
  • ‘_’ matches exactly one character
  • ‘#’ matches a single numeric digit
  • ‘[xyz]’ matches a single occurrence of one of the enclosed letters: x, y, or z
  • ‘[0-5]’ matches a single occurrence of this range of characters: 0 to 5

    • 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.