SQL Scratchpad

The SQL Scratchpad can be used to quickly experiment with creating your SQL statement. It allows you to parse and execute any SQL SELECT statement against the currently selected view.

Execute

Executes the SQL statement against the currently selected view. The output of the SQL statement will be displayed in one of the Results tabs. If the SQL statement cannot be executed the reason for the failure will be displayed in the Text Results tab.

Parse

Parses the provided SQL statement. Parsing a SQL statement is a quick way to detect syntax errors without the overhead of full statement execution.

SQL Statement

The SQL Select statement to be executed.

Results

SQL execution results will be displayed in one of the results tabs. The table results tab displays execution results in a table format. The text results tab displays execution results in a text-only format.

Row Count

The row count at the bottom of the window displays the number of results retrieved by the SQL statement.
Chapters
Topics
Pages
- Text Filter
- Log Level Filter
- Value Filter
- Date Time Filter
- SQL Filter
- Parse Message Filter
- Merge Filter
- Add Template
- Add Workspace
- Save Analysis
- Log File Properties
- Highlight Manager
- Edit Directory Monitor
- Time Offset
- Merge File Editor
- Bookmark Detail
- Search All Logs
- Search Results
- Transform Text
- SQL Scratchpad