TestCases

Retrieves a list of all test cases.

Table Specific Information

Select

The 本製品 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 本製品.

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

Deletes are not supported for this table. However, they can be performed through the DeleteTestCase stored procedure.

Columns


Name	Type	References	Description
Id [KEY]	Integer		Work item id.
LinksSelfHref	String		Self reference link.
LinksConfigurationHref	String		Configuration reference link.
LinksSourcePlanHref	String		Source plan reference link.
LinksSourceProjectHref	String		Source project reference link.
LinksSourceSuiteHref	String		Source suite reference link.
LinksTestPointsHref	String		Test points reference link.
Order	Integer		Order of the test case in the suite.
ProjectId	String		Id of the project.
ProjectLastUpdateTime	Date		Last updated time of the project.
ProjectName	String		Name of the project.
ProjectState	String		State of the project.
ProjectVisibility	String		Visibility of the project.
TestPlanId	Integer	TestPlans.Id	Id of the test plan.
TestPlanName	String		Name of the test plan.
TestSuiteId	Integer	TestSuites.Id	Id of the test suite.
TestSuiteName	String		Name of the test suite.
WorkItemName	String		Work item name.
WorkItemFields	String		Work item fields.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。