Lists
Represents all lists created on Trello boards, including their names and positions.
Table Specific Information
Select
The add-in 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. |