TestRunStatistics
Retrieves test run statistics, used when we want to get summary of a run by outcome.
Table Specific Information
Select
The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- RunId supports the '=' operator.
- ProjectId supports the '=' operator.
The rest of the filter is executed client-side in the add-in.
NOTE: RunId is required in order to query TestRunStatistics.
For example:
SELECT * FROM TestRunStatistics WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND RunId = 6
Columns
| Name | Type | References | Description |
| RunId | String |
TestRuns.Id | Id of the Test Run. |
| ProjectId | String | Id of the Project. | |
| Count | Integer | Test result count of the given outcome. | |
| Outcome | String | Test Result outcome. | |
| ResolutionStateId | Integer | Test Resolution State Id. | |
| ResolutionStateName | String | Test Resolution State Name. | |
| ResolutionStateProjectId | String | Test Resolution State Project Id. | |
| State | String | State of the Test Run. |