TestCases

Retrieves a list of all test cases.

Table Specific Information

Select

The connector 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 connector.

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.

For example:

	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.