FireDAC Components for Azure DevOps

Build 21.0.7930

TestRuns

Retrieves a list of test runs.

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.

  • ProjectId supports the '=' operator.
  • IsAutomated supports the '=' operator.
  • OwnerId supports the '=' operator.
  • PlanId supports the '=' operator.
  • RunId supports the '=' operator.
  • BuildUri supports the '=' operator.
  • IncludeRunDetails supports the '=' operator.
  • TmiRunId supports the '=' operator.
For example:
	SELECT * FROM TestRuns WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4'	
	SELECT * FROM TestRuns WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND Id = 6	
	SELECT * FROM TestRuns WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND IncludeRunDetails = true

Columns

Name Type References Description
Id [KEY] Integer Id of the Test Run.
BuildId String

Builds.Id

Id of the build associated with this test run.
BuildName String Name of the build associated with this test run.
BuildUrl String Url of the build associated with this test run.
Comment String Comments entered by those analyzing the run.
CompletedDate Datetime Completed date time of the run.
Controller String Test Run Controller.
CreatedDate Datetime Test Run CreatedDate.
DropLocation String Drop Location for the test run.
DueDate Datetime Due date and time for test run.
ErrorMessage String Error message associated with the run.
IncompleteTests Integer Number of Incomplete Tests.
IsAutomated Boolean True if test run is automated, false otherwise.
Iteration String The iteration to which the run belongs.
LastUpdatedByDisplayName String The non-unique display name of the user who last updated this test run.
LastUpdatedById String The Id of the user who last updated this test run.
LastUpdatedByImageUrl String The Image Url of the user who last updated this test run.
LastUpdatedByUniqueName String The unique name of the user who last updated this test run.
LastUpdatedByUrl String The Url of the user who last updated this test run.
LastUpdatedDate Datetime Last updated date and time.
Name String Name of the Test run.
NotApplicableTests Integer Number of Not Applicable Tests.
OwnerDisplayName String The non-unique display name of the owner.
OwnerId String The Id of the owner.
OwnerImageUrl String The Image URL of the owner.
OwnerUniqueName String The unique name of the owner.
OwnerUrl String The URL of the owner.
PassedTests Integer Number of passed tests in the run.
Phase String Phase/State for the test run
PlanId String

TestPlans.Id

Id of the test plan associated with this test run.
PlanName String Name of the test plan.
PlanUrl String URL of the test plan.
PostProcessState String Post Process State.
ProjectId String

Projects.Id

Id of the Project associated with this test run.
ProjectName String Name of the Project.
ProjectUrl String URL of the Project.
ReleaseId String

Releases.Id

Id of the Release.
ReleaseEnvironmentUri String Release Environment URI for test run.
ReleaseUri String Release Uri for test run.
Revision Integer Test run Revision.
StartedDate Datetime Start date time of the run.
State String The state of the run.
SubState String Test run Substate.
Tags String Tags attached with this test run.
TestEnvironmentId String Id of the Test Environment associated with this test run.
TestEnvironmentName String Name of the Test Environment associated with this test run.
TestMessageLogId Integer Test Message Log Id.
TestSettingsId String Id of the Test Settings.
TestSettingsName String Name of the Test Settings.
TestSettingsUrl String Url of the Test Settings.
TotalTests Integer Total tests in the run.
UnanalyzedTests Integer Number of failed tests in the run.
Url String Url of the test run.
WebAccessUrl String Web Access Url for test run.

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.

Name Type Description
BuildUri String URI of the build that the runs used.
IncludeRunDetails Boolean If true, include all the properties of the runs.
TmiRunId String Tmi Run Id.

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