IterationWorkItems
Retrieve work items for the specific iteration.
Table Specific Information
Select
The connector 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. |