BacklogColumnFields
Retrieves column 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 BacklogColumnFields.
For example:
SELECT * FROM BacklogColumnFields WHERE ProjectId = '03e4b7af-3bff-49d0' AND TeamId = '60efe1db-5742-4fe1' AND BacklogId = 'Microsoft.EpicCategory'
Columns
| Name | Type | References | Description |
| ProjectId [KEY] | String | Id of the project in which the backlog was created. | |
| TeamId [KEY] | String |
Teams.Id | Id of the team for which the backlog was created. |
| BacklogId [KEY] | String |
Backlogs.Id | Id of the backlog these column fields belong to. |
| ColumnFieldName [KEY] | String | The name of the column field. | |
| ColumnFieldReferenceName | String | The reference name of the column field. | |
| ColumnFieldUrl | String | The REST URL of the column field. | |
| Width | Integer | The width of the column. |