FireDAC Components for Azure DevOps

Build 21.0.7930

TestSuites

Retrieves all test suites.

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: PlanId or TestCaseId is required in order to query TestSuites.

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • PlanId supports the '=' operator.
  • TestCaseId supports the '=' operator.
  • Expand supports the '=' operator.
  • TreeView supports the '=' operator.
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

Columns

Name Type References Description
Id [KEY] Integer Id of the test suite.
TestCaseId String

TestCases.Id

Id of the test case.
LinksSelfHref String Self reference link.
LinksTestCasesHref String Test cases reference link.
LinksTestPointsHref String Test points reference link.
Children String Child test suites of current test suite.
DefaultConfigurations String Test suite default configurations.
DefaultTesters String Test suite default testers.
HasChildren Boolean Boolean value dictating if child test suites are present.
InheritDefaultConfigurations Boolean Default configuration was inherited or not.
LastError String Last error for test suite.
LastPopulatedDate Datetime Last populated date.
LastUpdatedByLinksAvatarHref String Avatar reference link of the user who last updated this test suite.
LastUpdatedByDescriptor String The descriptor is the primary way to reference the user who last updated this test suite while the system is running.
LastUpdatedByDisplayName String The non unique display name of the user who last updated this test suite.
LastUpdatedById String The Id of the user who last updated this test suite.
LastUpdatedByImageUrl String The Image URL of the user who last updated this test suite.
LastUpdatedByUniqueName String The Unique name of the user who last updated this test suite.
LastUpdatedByUrl String The unique name of the user who last updated this test suite.
LastUpdatedDate Datetime The date at which the suite was last updated.
Name String Name of the test suite.
ParentSuiteId Integer Id of the parent test suite.
ParentSuiteName String Name of the parent test suite.
PlanId Integer

TestPlans.Id

Id of the test plan to which this test suite belongs.
PlanName String Name of the test plan.
ProjectId String

Projects.Id

Id of the project.
ProjectName String Name of the project.
QueryString String Test suite query string, for dynamic suites.
RequirementId Integer Test suite requirement id.
Revision Integer Test suite revision.
SuiteType String 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.

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.

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