IterationWorkItems
Retrieve work items for the specific iteration.
Table Specific Information
Select
The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- ProjectId supports the '=' operator.
- TeamId supports the '=' operator.
- IterationId supports the '=' operator.
NOTE: IterationId is required in order to query IterationWorkItems.
For example:
SELECT * FROM IterationWorkItems WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND IterationId = '2bc932aa-21bd-4d2f-860d-43c843b46431'
Columns
Name | Type | References | Description |
ProjectId | String | Id of the project. | |
TeamId | String |
Teams.Id | Id of the team. |
IterationId | String | Id of the test iteration. | |
Rel | String | The type of link. | |
SourceId | Integer | The source work item Id. | |
SourceUrl | String | The source work item URL. | |
TargetId | Integer | The target work item Id. | |
TargetUrl | String | The target work item URL. |