16.20 - Filtering the History Table - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
  1. Right-click in the History window and select Filter.
  2. 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.