Toolbar

The toolbar exposes the following:

•      Export Query Trace Log: invocation of this option displays the Save Query Trace Log Windows file system dialog.  The default file type is set to Text Files, file name to 'Query Trace Log [yyyy]-[mm]-[dd]' and folder to the folder in which the client application is currently running.  You can click Save to save the Query Trace log to a file or Cancel to close the dialog without saving.

The file thus generated contains details of all of the displayed Query Trace logs (even if displayed across multiple pages. For each log entry, the following information is shown:

o  Execution type

o  Context

o  Query status

o  Query result

o  Started

o  Ended

o  Duration

o  File [name] ([GUID])

o  Activity [name] ([GUID]) (‘N/A’ if selection rule)

o  Workflow Instance ID

o  Query String

o  Error Message

Two hyphens are added at the beginning of any non-SQL lines of text within an exported Query Trace log.  The same applies at any error messages.  This makes it easier to execute the resultant SQL immediately in a SQL execution environment (e.g. SQL Server Management Studio).

•      Previous page: this option is enabled if multiple pages’ worth of Query Trace logs are shown, and a page other than the first is displayed.  Invocation returns to the previous page of results.

•      Next page: this option is enabled if multiple pages’ worth of Query Trace logs are shown, and a page other than the last is displayed.  Invocation moves to the next page of results.

•      Show/Hide Query Trace Log Search Options: this toggle button controls display of the search options toolbar.  It is selected by default.

•      Search: invocation of this option initiates search for all SQL logs matching the supplied search criteria.  Search results are displayed in the Query Trace Log grid.  A message is displayed when no matching records exist.

The search options toolbar exposes the following filter options:

•      Date from: the first date and time from which point Query Trace logs are to be displayed.  Date from defaults to 00:00 today.

•      Date to: the latest date and time to which point Query Trace logs are to be displayed.  Date to defaults to tomorrow, 00:00..

•      Show: a dropdown, which allows you to choose whether to view All Statuses (the default), or just Completed or Failed SQL statements’ logs.

•      Activity ID

•      Workflow Instance ID

Any specified filter options are applied automatically at Search invocation.