ADO.NET Provider for Azure DevOps

Build 24.0.9060

TestResultIterationDetails

Retrieves iteration details for the test result.

Table Specific Information

Select

The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • ProjectId supports the '=' operator.
  • TestRunId supports the '=' operator.
  • TestResultId supports the '=' operator.
  • IncludeActionResults supports the '=' operator.

The rest of the filter is executed client-side in the provider.


NOTE: TestRunId and TestResultId are required in order to query TestResultIterationDetails.

For example:

	SELECT * FROM TestResultIterationDetails WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestRunId = 6 AND TestResultId = 100001

Columns

Name Type References Description
Id [KEY] Integer ID of test iteration result.
ProjectId String Id of the project.
TestRunId Integer

TestRuns.Id

Id of the test run.
TestResultId Integer

TestResults.Id

Id of the test result.
ActionResults String Test step results in an iteration.
Comment String Comment in test iteration result.
CompletedDate Datetime Time when execution completed.
DurationInMs Integer Duration of execution.
ErrorMessage String Error message in test iteration result execution.
Outcome String Test outcome if test iteration result.
Parameters String Test parameters in an iteration.
StartedDate Datetime Time when execution started.
Url String Url to test iteration result.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.

Name Type Description
IncludeActionResults Boolean Indicates whether to include result details for each action performed in the test iteration.

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