Boards
Lists all boards that are available to the user.
Table Specific Information
Select
The 本製品 will use the Trello API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within 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'
We can retrieve public Trello Boards by providing their Id directly to the query. You can try the query below, which tries to retrieve data from the following board https://trello.com/board/trello-development/4d5ea62fd76aa1136000000c
To get the Id of a public board, append ".json" to the board URL ( https://trello.com/b/rq2mYJNn/public-trello-boards.json for example ) and you will see something like "{"id":"4e99eb7aa9797361bc22e6ce", ...". Take that id and use it in a query.
SELECT * FROM Boards WHERE BoardId = '4d5ea62fd76aa1136000000c'
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 | String | 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. |