BacklogPanelFields
Retrieves panel fields for 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:
- ProjectId supports the '=' operator.
- TeamId supports the '=' operator.
- BacklogId supports the '=' operator.
NOTE: Specifying the TeamId and BacklogId can improve the performance when querying BacklogPanelFields.
For example:
SELECT * FROM BacklogPanelFields WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' AND BacklogId = 'Microsoft.EpicCategory' SELECT * FROM BacklogPanelFields WHERE ProjectId = '03e4b7af-3bff-49d0' AND TeamId = '60efe1db-5742-4fe1' AND BacklogId = 'Microsoft.EpicCategory'
Columns
Name | Type | References | Description |
ProjectId | String | Id of the project in which the backlog was created. | |
TeamId | String |
Teams.Id | Id of the team for which the backlog was created. |
BacklogId | String |
Backlogs.Id | Id of the backlog these column fields belong to. |
Name | String | The name of the field. | |
ReferenceName | String | The reference name of the field. | |
Url | String | The REST URL of the field. |