Lists
Lists all the lists that have been created on boards.
Table Specific Information
Select
The connector 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. Closed column determines if the List has been archived or not. For example, the following query is processed server-side:
SELECT * FROM Lists WHERE BoardId = '4e99eb7aa9797361bc22e6ct' SELECT * FROM Lists WHERE ListId = '4e99eb7aa9797361bc22e6ct'
If BoardId is specified in connection properties,
SELECT * FROM Listswill return all lists of the board.
If OrganizationId is specified in connection properties
SELECT * FROM Listswill return all lists of the boards on that organization.
If BoardId and OrganizationId are not specified in connection properties
SELECT * FROM Listswill return all lists of the boards that the logged user is part of.
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. |