BoardRows
Retrieve rows on a board.
Table Specific Information
Select
The connector 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 connector.
- ProjectId supports the '=' operator.
- TeamId supports the '=' operator.
- BoardId supports the '=' operator.
SELECT * FROM BoardRows WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND BoardId = 'a1c17364-7447-47e6-9862-b10b78c3f09b' SELECT * FROM BoardRows 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 row. | |
| ProjectId | String | Id of the project in which this board row was created. | |
| TeamId | String |
Teams.Id | Id of the team this board row belongs to. |
| BoardId [KEY] | String |
Boards.Id | Id of the board this row belongs to. |
| Name | String | Name of the board row. |