Lists all boards that are available to the user.

Table Specific Information

Select

The driver 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

SELECT * FROM Boards WHERE Starred='true'

SELECT * FROM Boards WHERE OrganizationId='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'

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name	Type	Description
BoardID [KEY]	String	The Id of the Board
Name	String	The name of the Board
Pinned	Boolean	Determines if Board is pinned or not
Starred	Boolean	Determines if Board is starred or not
Closed	Boolean	Determines if Board is archived or not
Url	String	Board Url
DateLastView	Datetime	Time when it board was last viewed
MemberID	String	References the member of the board
OrganizationID	String	References the organization of which the board is part of
MyCustomFieldName	String	My custom field.