TestPlans
Get a list of test plans and details of specific test plan.
Table Specific Information
Select
The add-in 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 add-in.
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. | |
| Links | String | True |
Aggregate of the reference links. | |
| 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. | |
| 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. | |
| ProjectLastUpdateTime | Date | True |
Datetime when the project was last updated. | |
| 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. | |
| UpdatedDate | Datetime | True |
Updated date of the test plan. | |
| ItemUrl | String | True |
UI Url of the item. |
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. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
| Name | Type | Description |
| IncludePlanDetails | Boolean |
Get all properties of the test plan. |
| ActivePlans | Boolean |
Get just the active plans. |