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

Table Specific Information

Select

The connector 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 connector.

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.