QueryPairs can be filtered by clicking the arrow in the dropdown box labeled Show and selecting one of the five options (All QueryPairs, Completed, Not Started, Error, Failed).
The user may also switch the suite observed by click the arrow in the dropdown box labeled Test Suite and selecting a different Suite. If your Scenario contains only one suite, your selection will be limited to that one.
The QueryPair Grid is populated when a QueryPair is highlighted. This grid can be toggled to display Source, Target, and Failures results by clicking on the respective tabs. Just below the tabs there is an Export All button and at the lower left there is an Export to button. The Export All button produces an Excel file with Source, Target and comparison tabs, while the Export to button offers options to export results to Excel, CSV, and XML (see "Exporting Results" below for more details).
QueryPair Details is the tab located in the top right hand side of the Results Window. It is populated when a QueryPair is highlighted to the left of it in the center window. Details include:
- Source Row Count
- Target Row Count
- Row Count Difference
- Data Failures
- Source Query Duration
- Target Query Duration
- Target Connection
- Source Connection
Viewing Query Results
Similar to viewing the results of all QueryPairs in a suite, the user may view results for an individual QueryPair. When in Run Dashboard click the QueryPair Activity button in the top right hand side of the center panel. This toggles the panel from suite view to QueryPair view. Double clicking on a QueryPair brings up a new window displaying QueryPair Results. This window Displays only the QueryPair Grid.
As noted above, if you click on the Export to button (lower right), you can export a tab to either Excel, CSV, or XML formats. In each of these cases, QuerySurge will download to your browser a representation of the tabular results layout.
Note that the Data Failure and/or Non-matching Row flags on each row (see this article for more information) are also represented in each of these output formats. They show up as the following letter codes:
|ND||Non-keyed Data Failure|
|NN||Non-keyed Non-matching failure|