FireDAC Components for Azure DevOps

Build 21.0.7930


Get a list of test plans and details of specific test plan.

Table Specific Information


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.

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • OwnerId supports the '=' operator.
  • IncludePlanDetails supports the '=' operator.
  • ActivePlans supports the '=' operator.
For example:
	SELECT * FROM TestPlans WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4'
	SELECT * FROM TestPlans WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND OwnerId = '4dbc0cec-c473-652b-972f-f42587b4494d' AND IncludePlanDetails = true


Name Type References Description
Id [KEY] Integer Id of the test plan.
AreaPath String Area of the test plan.
BuildDefinitionId Integer


Id of the Build Definition that generates a build associated with this test plan.
BuildDefinitionName String Name of the Build Definition.
BuildId Integer


Build to be tested.
Description String Description of the test plan.
EndDate Datetime End date for the test plan.
Iteration String Iteration path of the test plan.
LinksSelfHref String Self Reference Link.
LinksBuildHref String Build Reference Link.
LinksClientUrlHref String Client Url Reference Link.
LinksRootSuiteHref String Root Suite Reference Link.
Name String Name of the test plan.
OwnerDisplayName String The non-unique display name of the owner.
OwnerUrl String The URL of the owner.
OwnerId String The Id of the owner.
OwnerUniqueName String The Unique name of the owner.
OwnerImageUrl String The Image Url of the owner.
PreviousBuildId Integer Previous build Id associated with the test plan.
ProjectId String


Id of the Project that contains the test plan.
ProjectName String Name of the Project.
ReleaseEnvironmentDefinitionId Integer Release Environment to be used to deploy the build and run automated tests from this test plan.
Revision Integer Revision of the test plan.
RootSuiteId Integer Id of the Root Suite of the test plan.
RootSuiteName String Name of the Root Suite of the test plan.
StartDate Datetime Start date for the test plan.
State String State of the test plan.
SyncOutcomeAcrossSuites Boolean Value to configure how same tests across test suites under a test plan need to behave.
UpdatedByDisplayName String The non-unique display name of the user who last updated this test plan.
UpdatedByUrl String The URL of the user.
UpdatedById String The Id of the user.
UpdatedByUniqueName String The Unique Name of the user.
UpdatedByImageUrl String The Image URL of the user.
UpdatedDate Datetime Updated date of the test plan.


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
IncludePlanDetails Boolean Get all properties of the test plan.
ActivePlans Boolean Get just the active plans.

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