ODBC Driver for Azure DevOps

Build 22.0.8479


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

Table Specific Information


The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • OwnerId supports the '=' operator.
  • IncludePlanDetails supports the '=' operator.
  • ActivePlans supports the '=' operator.

The rest of the filter is executed client-side in the 本製品.

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


The following is an example of inserting into a TestPlans table:

INSERT INTO TestPlans (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937','cdata')


The following is an example of updating a TestPlans table:

UPDATE TestPlans SET Name = 'cdata2' WHERE ProjectId ='b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'


The following is an example of deleting data in a TestPlans table:

DELETE FROM TestPlans WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'


Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the test plan.

AreaPath String False

Area of the test plan.

BuildDefinitionId Integer False


Id of the Build Definition that generates a build associated with this test plan.

BuildDefinitionName String False

Name of the Build Definition.

BuildId Integer False


Build to be tested.

Description String False

Description of the test plan.

EndDate Datetime False

End date for the test plan.

Iteration String False

Iteration path of the test plan.

LinksSelfHref String True

Self Reference Link.

LinksBuildHref String True

Build Reference Link.

LinksClientUrlHref String True

Client Url Reference Link.

LinksRootSuiteHref String True

Root Suite Reference Link.

Name String False

Name of the test plan.

OwnerDisplayName String False

The non-unique display name of the owner.

OwnerUrl String False

The URL of the owner.

OwnerId String False

The Id of the owner.

OwnerUniqueName String False

The Unique name of the owner.

OwnerImageUrl String False

The Image Url of the owner.

PreviousBuildId Integer True

Previous build Id associated with the test plan.

ProjectId String True


Id of the Project that contains the test plan.

ProjectName String True

Name of the Project.

ReleaseEnvironmentDefinitionId Integer False

Release Environment to be used to deploy the build and run automated tests from this test plan.

Revision Integer True

Revision of the test plan.

RootSuiteId Integer True

Id of the Root Suite of the test plan.

RootSuiteName String True

Name of the Root Suite of the test plan.

StartDate Datetime False

Start date for the test plan.

State String False

State of the test plan.

SyncOutcomeAcrossSuites Boolean False

Value to configure how same tests across test suites under a test plan need to behave.

UpdatedByDisplayName String True

The non-unique display name of the user who last updated this test plan.

UpdatedByUrl String True

The URL of the user.

UpdatedById String True

The Id of the user.

UpdatedByUniqueName String True

The Unique Name of the user.

UpdatedByImageUrl String True

The Image URL of the user.

UpdatedDate Datetime True

Updated date of the test plan.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
IncludePlanDetails Boolean

Get all properties of the test plan.

ActivePlans Boolean

Get just the active plans.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479