TestSuites
Retrieves all test suites.
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.
- PlanId supports the '=' operator.
- Expand supports the '=' operator.
- TreeView supports the '=' operator.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM TestSuites WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND PlanId = 296 SELECT * FROM TestSuites WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND PlanId = 296 AND Expand = 'children' SELECT * FROM TestSuites WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND PlanId = 296 AND TreeView = true
Insert
The following are examples of inserting into TestSuites table:
INSERT INTO TestSuites (ProjectId, PlanId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 1, 'Shubham')
INSERT INTO TestSuites (ProjectId, PlanId, Name, SuiteType, ParentSuiteId, InheritDefaultConfigurations) VALUES ('c831d3b4-a289-462f', 1, 'Sample TestSuite', 'Sample-Test-TFVC', 85, true)
Update
The following is an example of updating a TestSuites table:
UPDATE TestSuites SET Name = 'cdata2' WHERE Id = '1' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND PlanId = '1'
Delete
The following is an example of deleting data in a TestSuites table:
DELETE FROM TestSuites WHERE Id = '1' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND PlanId = '1'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
Id of the test suite. | |
| Links | String | True |
Aggregate of the reference links. | |
| Children | String | True |
Child test suites of current test suite. | |
| DefaultConfigurations | String | False |
Test suite default configurations. | |
| DefaultTesters | String | False |
Test suite default testers. | |
| HasChildren | Boolean | True |
Boolean value dictating if child test suites are present. | |
| InheritDefaultConfigurations | Boolean | False |
Default configuration was inherited or not. | |
| LastError | String | True |
Last error for test suite. | |
| LastPopulatedDate | Datetime | True |
Last populated date. | |
| LastUpdatedByLinksAvatarHref | String | True |
Avatar reference link of the user who last updated this test suite. | |
| LastUpdatedByDescriptor | String | True |
The descriptor is the primary way to reference the user who last updated this test suite while the system is running. | |
| LastUpdatedByDisplayName | String | True |
The non unique display name of the user who last updated this test suite. | |
| LastUpdatedById | String | True |
The Id of the user who last updated this test suite. | |
| LastUpdatedByUrl | String | True |
The unique name of the user who last updated this test suite. | |
| LastUpdatedDate | Datetime | True |
The date at which the suite was last updated. | |
| Name | String | False |
Name of the test suite. | |
| ParentSuiteId | Integer | False |
Id of the parent test suite. | |
| ParentSuiteName | String | False |
Name of the parent test suite. | |
| PlanId | Integer | True |
TestPlans.Id |
Id of the test plan to which this test suite belongs. |
| PlanName | String | True |
Name of the test plan. | |
| ProjectId | String | True |
Id of the project. | |
| ProjectName | String | True |
Name of the project. | |
| QueryString | String | False |
Test suite query string, for dynamic suites. | |
| RequirementId | Integer | False |
Test suite requirement id. | |
| Revision | Integer | True |
Test suite revision. | |
| SuiteType | String | False |
Test suite type. |
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 |
| Expand | String |
Include the children suites. The allowed values are children, defaultTesters, none. |
| TreeView | Boolean |
If the suites returned should be in a tree structure. |