Lists all the lists that have been created on boards.

Table-Specific Information

Select

The connector pushes supported filters in the WHERE clause to the Trello API. Remaining filters are applied client-side in the driver. For example, the following queries are processed server-side:

SELECT * FROM Lists WHERE BoardId = '4e99eb7aa9797361bc22e6ct'

SELECT * FROM Lists WHERE ListId = '4e99eb7aa9797361bc22e6ct'

For queries without a WHERE clause, such as SELECT * FROM Lists, the results depend on the connection properties you set.

• If BoardId is specified, a query without a WHERE clause returns Lists from that board.
• If OrganizationId is specified, the query returns Lists from boards in that organization.
• If neither is specified, the query returns Lists from boards that the authenticated user is part of.

Update

Use UPDATE statements to modify existing records in this table.

UPDATE Lists SET Name = 'Updated List Name' WHERE ListId = '670fb682a80214147aa5e322';

UPDATE Lists SET Name = 'Testing-two-step-update-ListsTable', Closed = 'True', Position = 150, Subscribed = 'true', BoardId = '670f861eec1d821ddba24a6e' WHERE ListId = '670fb682a80214147aa5e322';

Columns