BacklogWorkItems
Retrieves a list of work items within a backlog level.
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.
- BacklogId supports the '=' operator.
NOTE: Specifying the TeamId and BacklogId can improve the performance when querying BacklogWorkItems.
For example:
SELECT * FROM BacklogWorkItems WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' AND BacklogId = 'Microsoft.EpicCategory'
Columns
Name | Type | References | Description |
ProjectId | String | Id of the project in which the backlog was created. | |
TeamId | String |
Teams.Id | Id of the team for which the backlog was created. |
BacklogId | String |
Backlogs.Id | Id of the backlog. |
Rel | String | The type of link. | |
SourceId | Integer | Source work item ID. | |
SourceUrl | String | REST API URL of the source. | |
TargetId | Integer | Target work item ID. | |
TargetUrl | String | REST API URL of the target. |