SSIS Components for Azure DevOps

Build 24.0.9063

TestSuites

Retrieves all test suites.

Table Specific Information

Select

The 本製品 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.
  • Expand supports the '=' operator.
  • TreeView supports the '=' operator.

The rest of the filter is executed client-side in the 本製品.

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

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.

Links String True

Aggregate of the reference links.

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.

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

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

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

Name Type Description
Expand String

Include the children suites.

使用できる値は次のとおりです。children, defaultTesters, none

TreeView Boolean

If the suites returned should be in a tree structure.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063