Backlogs
Retrieves all backlog levels and details of the specific 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:
- Id supports the '=' operator.
- ProjectId supports the '=' operator.
- TeamId supports the '=' operator.
NOTE: TeamId is required in order to query BacklogPanelFields.
For example:
SELECT * FROM Backlogs WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' SELECT * FROM Backlogs WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' AND Id = 'Microsoft.EpicCategory'
Columns
Name | Type | References | Description |
Id [KEY] | String | Unique Id of the backlog. | |
ProjectId | String | Id of the project in which this backlog was created. | |
TeamId | String |
Teams.Id | Id of the team for which this backlog was created. |
Color | String | The color of the backlog level. | |
DefaultWorkItemTypeName | String | The name of the field. | |
DefaultWorkItemTypeReferenceName | String | The reference name of the field. | |
DefaultWorkItemTypeUrl | String | The REST URL of the field. | |
IsHidden | Boolean | Indicates whether the backlog level is hidden. | |
Name | String | The name of the backlog. | |
Rank | Integer | Backlog rank (task backlog is 0). | |
Type | String | The type of this backlog level. | |
WorkItemCountLimit | Integer | Max number of work items to show in the given backlog. |