Boards
Lists all boards that are available to the user.
Table-Specific Information
Select
The 本製品 pushes supported filters in the WHERE clause to the Trello API. Remaining filters are applied client-side in the driver. For example, the following query is processed server-side:
SELECT * FROM Boards WHERE OrganizationId = '583558863c5859587053200c'
SELECT * FROM Boards WHERE BoardId = '583558863c5859587053200c'
SELECT * FROM Boards WHERE MemberId = '583558863c5859587053200c'
You can retrieve public Trello Boards by providing their Id directly in the query. For example, the following query retrieves data from the board at https://trello.com/board/trello-development/4d5ea62fd76aa1136000000c.
To get the Id of a public board, append ".json" to the board URL (for example: https://trello.com/b/rq2mYJNn/public-trello-boards.json).
The JSON response includes an Id value, which you can then use in your query.
SELECT * FROM Boards WHERE BoardId = '4d5ea62fd76aa1136000000c'
Delete
Use DELETE statements to remove records from this table.
DELETE FROM Boards WHERE BoardId = '66feb4169ff3e6311396f662';
Columns
| Name | Type | ReadOnly | Description |
| BoardID [KEY] | String | True |
The Id of the Board |
| Name | String | True |
The name of the Board. |
| Description | String | True |
The description of the board. |
| Pinned | Boolean | True |
Determines if Board is pinned or not. |
| Starred | Boolean | True |
Determines if Board is starred or not. |
| Closed | Boolean | True |
Determines if Board is archived or not. |
| Url | String | True |
Board Url. |
| Subscribed | Boolean | True |
Indicates if the user is subscribed to the board. |
| DateLastActivity | Datetime | True |
Timestamp of the most recent activity on the board. |
| DateLastView | Datetime | True |
Time when it board was last viewed. |
| CreationMethod | String | True |
Indicates how the board was created. |
| MemberID | String | True |
References the member of the board. |
| OrganizationID | String | True |
References the organization of which the board is part of. |
| EnterpriseOwned | Boolean | True |
Determines if the board is enterprise owned. |
| PermissionLevel | String | True |
Permission level of the board (private, organization, public). |
| HideVotes | Boolean | True |
Determines if votes can be shown or not. |
| Voting | String | True |
Determines if voting is allowed. |
| Comments | String | True |
Determines the user level which can comment. |
| Invitations | String | True |
Determines the user level which can invite. |
| SelfJoin | Boolean | True |
Determines if self join is enabled. |
| IsTemplate | Boolean | True |
Determines if the board is a template. |
| CardCovers | Boolean | True |
Determines if cards should have covers or not. |
| CardAging | String | True |
Determines what style the cards will get if they stay for too long in a list. |
| CalendarFeedEnabled | Boolean | True |
Determines if the calendar feed is enabled. |
| Background | String | True |
Background color. |
| BackgroundImage | String | True |
Background image. |
| BackgroundImageScaled | String | True |
Background image. |
| BackgroundTile | Boolean | True |
Background tile. |
| BackgroundBrightness | String | True |
Background brightness. |
| BackgroundColor | String | True |
Background color. |
| BackgroundBottomColor | String | True |
Bottom background color. |
| BackgroundTopColor | String | True |
Top background color. |
| CanBePublic | Boolean | True |
Determines if the board can be public. |
| CanBeEnterprise | Boolean | True |
Determines if the board can be enterprise. |
| CanBeOrg | Boolean | True |
Determines if the board can be an organization. |
| CanBePrivate | Boolean | True |
Determines if the board can be private. |
| CanInvite | Boolean | True |
Determines if invitations are enabled. |
| MyCustomFieldName | String | True |
A JSON aggregates value containing the custom fields of the board. To retrieve these, IncludeCustomFields property must be enabled and a BoardId must be specified. |