TestPlans
Get a list of test plans and details of specific test plan.
Table Specific Information
Select
The driver 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 driver.
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
Insert
The following is an example of inserting into a TestPlans table:
INSERT INTO TestPlans (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937','cdata')
Update
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'
Delete
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'
Columns
| 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 |
Builds.Id |
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 |
Projects.Id |
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. |
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 |
| IncludePlanDetails | Boolean |
Get all properties of the test plan. |
| ActivePlans | Boolean |
Get just the active plans. |