TestCasePointAssignments
Retrieves point assignments for the specific test case.
Table Specific Information
Select
The connector 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 connector.
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. |