ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves iteration details for the test result.

Table Specific Information


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

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


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


Id of the project.
TestRunId Integer


Id of the test run.
TestResultId Integer


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.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479