SSIS Components for Azure DevOps

Build 24.0.9060

TestCasePointAssignments

Retrieves point assignments for the specific test case.

Table Specific Information

Select

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

  • Id supports the '=,in' operators.
  • ProjectId supports the '=' operator.
  • TestPlanId supports the '=' operator.
  • TestSuiteId supports the '=' operator.
  • ConfigurationIds supports the 'in' operator.

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

NOTE: TestPlanId, TestSuiteId, and TestCaseId are required in order to query TestCasePointAssignments.

For example:

SELECT * FROM TestCasePointAssignments WHERE ProjectId = '03e4b7af-3bff-49d0' AND TestPlanId = 1 AND TestSuiteId = 2 AND TestCaseId = 1

Columns

Name Type References Description
Id Integer Id of the test case point.
ProjectId String Id of the Project.
TestPlanId Integer

TestPlans.Id

Id of the test plan.
TestSuiteId Integer

TestSuites.Id

Id of the test suite.
TestCaseId String

TestCases.Id

Id of the test case.
ConfigurationId Integer Id of the Configuration Assigned to the test point.
ConfigurationName String Name of the Configuration Assigned to the test point.
TesterLinksAvatarHref String Reference links.
TesterDisplayName String The non-unique display name of the tester.
TesterId String The Id of the tester.
TesterUrl String The URL of the tester.

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