JDBC Driver for Azure DevOps

Build 22.0.8462

TestSuites

Retrieves all test suites.

Table Specific Information

Select

The driver uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • PlanId supports the '=' operator.
  • TestCaseId supports the '=' operator.
  • Expand supports the '=' operator.
  • TreeView supports the '=' operator.

The rest of the filter is executed client-side in the driver.

NOTE: PlanId or TestCaseId is required in order to query TestSuites.

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
	SELECT * FROM TestSuites WHERE TestCaseId=1

Insert

The following are examples of inserting into TestSuites table:

INSERT INTO TestSuites (ProjectId,PlanId,Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937',1,'Shubham')
INSERT INTO TestSuites (ProjectId, PlanId, Name, SuiteType, ParentSuiteId, InheritDefaultConfigurations) VALUES ('c831d3b4-a289-462f', 1, 'Sample TestSuite', 'Sample-Test-TFVC', 85, true)

Update

The following is an example of updating a TestSuites table:

UPDATE TestSuites SET Name = 'cdata2' WHERE Id = '1' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND PlanId = '1'

Delete

The following is an example of deleting data in a TestSuites table:

DELETE FROM TestSuites WHERE Id = '1' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND PlanId = '1'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the test suite.

TestCaseId String True

TestCases.Id

Id of the test case.

LinksSelfHref String True

Self reference link.

LinksTestCasesHref String True

Test cases reference link.

LinksTestPointsHref String True

Test points reference link.

Children String True

Child test suites of current test suite.

DefaultConfigurations String False

Test suite default configurations.

DefaultTesters String False

Test suite default testers.

HasChildren Boolean True

Boolean value dictating if child test suites are present.

InheritDefaultConfigurations Boolean False

Default configuration was inherited or not.

LastError String True

Last error for test suite.

LastPopulatedDate Datetime True

Last populated date.

LastUpdatedByLinksAvatarHref String True

Avatar reference link of the user who last updated this test suite.

LastUpdatedByDescriptor String True

The descriptor is the primary way to reference the user who last updated this test suite while the system is running.

LastUpdatedByDisplayName String True

The non unique display name of the user who last updated this test suite.

LastUpdatedById String True

The Id of the user who last updated this test suite.

LastUpdatedByImageUrl String True

The Image URL of the user who last updated this test suite.

LastUpdatedByUniqueName String True

The Unique name of the user who last updated this test suite.

LastUpdatedByUrl String True

The unique name of the user who last updated this test suite.

LastUpdatedDate Datetime True

The date at which the suite was last updated.

Name String False

Name of the test suite.

ParentSuiteId Integer False

Id of the parent test suite.

ParentSuiteName String False

Name of the parent test suite.

PlanId Integer True

TestPlans.Id

Id of the test plan to which this test suite belongs.

PlanName String True

Name of the test plan.

ProjectId String True

Projects.Id

Id of the project.

ProjectName String True

Name of the project.

QueryString String False

Test suite query string, for dynamic suites.

RequirementId Integer False

Test suite requirement id.

Revision Integer True

Test suite revision.

SuiteType String False

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462