Lists
Lists all the lists that have been created on boards.
Table Specific Information
Select
The server uses the Trello API to process WHERE clause conditions built with the following columns and operators. The rest of the filter executes client-side within the driver. The Closed column determines if the List has been archived or not. The following query is processed server-side.
For example:
SELECT * FROM Lists WHERE BoardId = '4e99eb7aa9797361bc22e6ct' SELECT * FROM Lists WHERE ListId = '4e99eb7aa9797361bc22e6ct'
If BoardId is specified in the connection properties, the following query returns all lists from that board.
SELECT * FROM Lists
If OrganizationId is specified in the connection properties, the following query returns all lists from boards associated with that organization.
SELECT * FROM Lists
If BoardId and OrganizationId are not specified in the connection properties, the following query returns all lists of boards that the logged-in user is part of.
SELECT * FROM Lists
Columns
| Name | Type | ReadOnly | Description |
| ListId [KEY] | String | True |
The Id of the list. |
| Name | String | False |
The name of the list. |
| Position | Double | False |
The position of the list. |
| Closed | Boolean | False |
Determines if the list is closed {archived}. |
| Subscribed | Boolean | False |
Whether the active member is subscribed to this list. |
| BoardID | String | False |
The id of the board where the list is created. |