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