ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves all backlog levels and details of the specific backlog level.

Table Specific Information


The 本製品 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.
The rest of the filter is executed client-side in the 本製品.

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'


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


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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479