Backlogs
Retrieves all backlog levels and details of the specific backlog level.
Table Specific Information
Select
The adapter 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. |