BoardColumns
Retrieve columns on a board.
Table Specific Information
Select
The driver 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.
- BoardId supports the '=' operator.
NOTE: BoardId is required in order to query BoardColumns.
For example:
SELECT * FROM BoardColumns WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND BoardId = 'a1c17364-7447-47e6-9862-b10b78c3f09b' SELECT * FROM BoardColumns WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' AND BoardId = 'a1c17364-7447-47e6-9862-b10b78c3f09b'
Columns
Name | Type | References | Description |
Id [KEY] | String | Id of the board column. | |
ProjectId | String |
Projects.Id | Id of the project in which this was created. |
TeamId | String |
Teams.Id | Id of the team this board belongs to. |
BoardId | String |
Boards.Id | Id of the board this column belongs to. |
ColumnType | String | The type of the column. | |
Description | String | The description of the column. | |
IsSplit | Boolean | Indicates if the column is split. | |
ItemLimit | Integer | The limit of the items. | |
Name | String | The name of the column. | |
StateMappings | String | State mappings. |