BacklogPanelFields
Retrieves panel fields for 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:
- 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. |