SSIS Components for Azure DevOps

Build 24.0.9063

TestSubResults

Retrieves sub results 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.

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 TestSubResults WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestRunId = 6 AND TestResultId = 100001

Columns

Name Type References Description
Id Integer ID of test sub 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.
Comment String Comment in test sub result.
CompletedDate Datetime Time when execution completed.
ComputerName String Machine where test executed.
ConfigurationId String Id of the Test Configuration.
ConfigurationName String Name of the Test Configuration.
ConfigurationUrl String Url of the Test Configuration.
DisplayName String Name of sub result.
DurationInMs Integer Duration of execution.
ErrorMessage String Error message in test iteration result execution.
LastUpdatedDate Datetime Last updated datetime of test result.
Outcome String Test outcome if test iteration result.
ParentId Integer Immediate parent ID of sub result.
ResultGroupType String Hierarchy type of the result, default value of None means its leaf node.
SequenceId Integer Index number of sub result.
StackTrace String Stacktrace with maxSize= 1000 chars.
StartedDate Datetime Time when test execution started.
Url String Url to sub result.

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