TestPlans
Get a list of test plans and details of specific test plan.
Table Specific Information
Select
The connector 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 connector.
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. | |
| 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. |
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. |