FireDAC Components for Azure DevOps

Build 21.0.7930

TestCases

Retrieves a list of all test cases.

Table Specific Information

Select

The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
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)

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

Projects.Id

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.
WorkItemId Integer Work item Id.
WorkItemName String Work item name.
WorkItemFields String 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.

Name Type Description
ConfigurationIds String Fetch Test Cases which contains all the configuration Ids specified.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930