TestCases
Retrieves a list of all test cases.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
The rest of the filter is executed client-side in the provider.
NOTE: TestPlanId and TestSuiteId is required in order to query TestCases.
- Id supports the '=,in' operators.
- ProjectId supports the '=' operator.
- TestPlanId supports the '=' operator.
- TestSuiteId supports the '=' operator.
- ConfigurationIds supports the 'in' operator.
SELECT * FROM TestCases WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestPlanId = 296 AND TestSuiteId = 298 SELECT * FROM TestCases WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestPlanId = 296 AND TestSuiteId = 298 AND ConfigurationIds IN (7, 10) SELECT * FROM TestCases WHERE ProjectId = '03e4b7af-3bff-49d0' AND TestPlanId = 1 AND TestSuiteId = 2
Delete
The following is an example of deleting data in a TestCases table:
DELETE FROM TestCases WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '10'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
Work item id. | |
LinksSelfHref | String | True |
Self reference link. | |
LinksConfigurationHref | String | True |
Configuration reference link. | |
LinksSourcePlanHref | String | True |
Source plan reference link. | |
LinksSourceProjectHref | String | True |
Source project reference link. | |
LinksSourceSuiteHref | String | True |
Source suite reference link. | |
LinksTestPointsHref | String | True |
Test points reference link. | |
Order | Integer | True |
Order of the test case in the suite. | |
ProjectId | String | True |
Id of the project. | |
ProjectLastUpdateTime | Date | True |
Last updated time of the project. | |
ProjectName | String | True |
Name of the project. | |
ProjectState | String | True |
State of the project. | |
ProjectVisibility | String | True |
Visibility of the project. | |
TestPlanId | Integer | True |
TestPlans.Id |
Id of the test plan. |
TestPlanName | String | True |
Name of the test plan. | |
TestSuiteId | Integer | True |
TestSuites.Id |
Id of the test suite. |
TestSuiteName | String | True |
Name of the test suite. | |
WorkItemName | String | True |
Work item name. | |
WorkItemFields | String | True |
Work item fields. |
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 |
ConfigurationIds | String |
Fetch Test Cases which contains all the configuration Ids specified. |