Boards
Retrieve boards for the specific project and details of the specified board.
Table Specific Information
Select
The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
The rest of the filter is executed client-side in the add-in.
- Id supports the '=' operator.
- ProjectId supports the '=' operator.
- TeamId supports the '=' operator.
SELECT * FROM Boards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' SELECT * FROM Boards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id = 'a1c17364-7447-47e6-9862-b10b78c3f09b' SELECT * FROM Boards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' SELECT * FROM Boards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' AND Id = 'a1c17364-7447-47e6-9862-b10b78c3f09b'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Id of the board | |
| ProjectId | String | Id of the Project in which this board was created | |
| TeamId | String |
Teams.Id | Id of the Team to which this board belongs to |
| AllowedMappings | String | Allowed mappings. This field will be populated with a value only when the Id is specified. | |
| CanEdit | Boolean | Indicates if the board can be edited. This field will be populated with a value only when the Id is specified. | |
| FieldsColumnFieldReferenceName | String | Reference name for the column field. this field will be populated with a value only when the Id is specified. | |
| FieldsColumnFieldUrl | String | Full Http link for the column field. this field will be populated with a value only when the Id is specified. | |
| FieldsDoneFieldReferenceName | String | Reference name for the done field. this field will be populated with a value only when the Id is specified. | |
| FieldsDoneFieldUrl | String | Full Http link for the done field. this field will be populated with a value only when the Id is specified. | |
| FieldsRowFieldReferenceName | String | Reference name for the row field. this field will be populated with a value only when the Id is specified. | |
| FieldsRowFieldUrl | String | Full Http link for the row field. this field will be populated with a value only when the Id is specified. | |
| IsValid | Boolean | Indicates whether this board is valid or not. This field will be populated with a value only when the Id is specified. | |
| Links | String | Aggregate of the reference links. | |
| Name | String | The name of the board | |
| Revision | Integer | The revision of the board. This field will be populated with a value only when the Id is specified. | |
| Url | String | The full http link to the board |