FireDAC Components for Azure DevOps

Build 21.0.7930

TestResults

Retrieves test results for a test run.

Table Specific Information

Select

The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
Note: TestRunId is required in order to query TestResults.

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • TestRunId supports the '=' operator.
  • Outcome supports the '=' operator.
For example:
	SELECT * FROM TestResults WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestRunId = 6

Columns

Name Type References Description
Id [KEY] Integer Id of the Test Result.
AfnStripId Integer Test Attachment Id of action recording.
AreaId String Id of the Area Path Of Test.
AreaName String Name of the Area Path of Test.
AreaUrl String URL of the Area Path of Test.
AssociatedBugs String Reference to bugs linked to test result.
AutomatedTestId String ID representing test method in a dll.
AutomatedTestName String Fully qualified name of test executed.
AutomatedTestStorage String Container to which test belongs.
AutomatedTestType String Type of automated test.
AutomatedTestTypeId String TypeId of automated test.
BuildId String

Builds.Id

Id of the Build associated with this test result.
BuildName String Name of the Build.
BuildUrl String URL of the Build.
Comment String Comment in a test result with maxSize= 1000 chars.
CompletedDate Datetime Time when test execution completed.
ComputerName String Machine name where test executed.
ConfigurationId String Id of the Test Configuration.
ConfigurationName String Name of the Test Configuration.
ConfigurationUrl String Url of the Test Configuration.
CreatedDate Datetime Timestamp when test result created.
DurationInMs Integer Duration of test execution in milliseconds.
ErrorMessage String Error message in test execution.
FailingSinceBuildSystem String Build System.
FailingSinceBuildDefinitionId Integer Build Definition Id since tests are failing.
FailingSinceBuildId Integer Build Id since tests are failing.
FailingSinceBuildNumber String Build Number.
FailingSinceDate Datetime Time since failing.
FailingSinceReleaseId Integer Release reference since failing.
FailureType String Failure type of test result.
LastUpdatedByDisplayName String The non-unique display name of the user who last updated this test result.
LastUpdatedById String The Id of the user who last updated this test result.
LastUpdatedByImageUrl String The Image Url of the user who last updated this test result.
LastUpdatedByUniqueName String The Unique name of the user.
LastUpdatedByUrl String The URL of the user.
LastUpdatedDate Datetime Last updated datetime of test result.
Outcome String Test outcome of test result.
OwnerId String The Id of the owner of the test.
OwnerName String The name of the owner.
OwnerUrl String The URL of the Owner.
Priority Integer Priority of test executed.
ProjectId String

Projects.Id

Id of the Project.
ProjectName String Name of the Project.
ProjectUrl String URL of the Project.
ReleaseId Integer Id of the release associated with this result.
ReleaseName String Name of the release associated with this result.
ReleaseUrl String Url of the release associated with this result.
ResetCount Integer ResetCount.
ResolutionState String Resolution state of test result.
ResolutionStateId Integer ID of resolution state.
ResultGroupType String Hierarchy type of the result, default value of None means its leaf node.
Revision Integer Revision number of test resul.
RunByDisplayName String The non-unique display name of the user who executed the test.
RunById String The Id of the user who executed the test.
RunByImageUrl String The Image URL of the user who executed the test.
RunByUniqueName String The Unique Name of the user who executed the test.
RunByUrl String The URL of the user who executed the test.
StackTrace String Stacktrace with maxSize= 1000 chars.
StartedDate Datetime Time when test execution started.
State String State of test result.
TestCaseId String

TestCases.Id

Id of the Test case executed.
TestCaseName String Name of the Test case executed.
TestCaseUrl String Url of the Test case executed.
TestCaseReferenceId Integer Reference ID of test used by test result.
TestCaseRevision Integer TestCaseRevision Number.
TestCaseTitle String Name of test.
TestPlanId String

TestPlans.Id

Id of The Test Plan test case work item is part of.
TestPlanName String Name of the Test Plan.
TestPlanUrl String Url of the Test Plan.
TestPointId String

TestPoints.Id

Id of the Test Point Executed.
TestPointName String Name of the Test Point Executed.
TestPointUrl String Url of the Test Point Executed.
TestRunId String

TestRuns.Id

Id of the Test Run.
TestRunName String Name of the Test Run.
TestRunUrl String Url of the Test Run.
TestSuiteId String

TestSuites.Id

Id of the Test Suite test case workitem is part of.
TestSuiteName String Name of the Test Suite.
TestSuiteUrl String Url of the Test Suite.
Url String Url of the Test Result.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930