FireDAC Components for Azure DevOps

Build 21.0.7930


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

Table Specific Information


The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
Note: TeamId is required in order to query BacklogPanelFields.

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • TeamId supports the '=' operator.
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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930