SSIS Components for Azure DevOps

Build 24.0.9063

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

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

DELETE FROM TestCases WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '10'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Work item id.

LinksSelfHref String True

Self reference link.

LinksConfigurationHref String True

Configuration reference link.

LinksSourcePlanHref String True

Source plan reference link.

LinksSourceProjectHref String True

Source project reference link.

LinksSourceSuiteHref String True

Source suite reference link.

LinksTestPointsHref String True

Test points reference link.

Order Integer True

Order of the test case in the suite.

ProjectId String True

Id of the project.

ProjectLastUpdateTime Date True

Last updated time of the project.

ProjectName String True

Name of the project.

ProjectState String True

State of the project.

ProjectVisibility String True

Visibility of the project.

TestPlanId Integer True

TestPlans.Id

Id of the test plan.

TestPlanName String True

Name of the test plan.

TestSuiteId Integer True

TestSuites.Id

Id of the test suite.

TestSuiteName String True

Name of the test suite.

WorkItemName String True

Work item name.

WorkItemFields String True

Work item fields.

Pseudo-Columns

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

Name Type Description
ConfigurationIds String

Fetch Test Cases which contains all the configuration Ids specified.

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