SSIS Components for Azure DevOps

Build 24.0.9063

TestResultIterationDetails

Retrieves iteration details for the test result.

Table Specific Information

Select

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

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

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.9063