TestSuites
Retrieves all test suites.
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.
- PlanId supports the '=' operator.
- Expand supports the '=' operator.
- TreeView supports the '=' operator.
The rest of the filter is executed client-side in the driver.
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. |