ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves point assignments for the specific test case.

Table Specific Information


The 本製品 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 本製品.

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


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


Id of the Project.
TestPlanId Integer


Id of the test plan.
TestSuiteId Integer


Id of the test suite.
TestCaseId String


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.
TesterImageUrl String The Image URL of the tester.
TesterUniqueName String The Unique Name of the tester.
TesterUrl String The URL of the tester.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479