Excel Add-In for Azure DevOps

Build 24.0.9062

TestRunStatistics

Retrieves test run statistics, used when we want to get summary of a run by outcome.

Table Specific Information

Select

The 本製品 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 本製品.


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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062