ODBC Driver for Trello

Build 20.0.7587

Lists

Lists all the lists that have been created on boards.

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: Closed column determines if the List has been archived or not.

SELECT * FROM Lists

SELECT * FROM Lists WHERE Closed='false'

SELECT * FROM Lists WHERE BoardId='4e99eb7aa9797361bc22e6ct'

If BoardId is specified in connection properties,

SELECT * FROM Lists
will return all lists of the board.

If OrganizationId is specified in connection properties

SELECT * FROM Lists
will return all lists of the boards on that organization.

If BoardId and OrganizationId are not specified in connection properties

SELECT * FROM Lists
will return all lists of the boards that the logged user is part of.

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
ListId [KEY] String The Id of the list.
Name String The name of the list.
Position Double The position of the list.
BoardID String The id of the board where the list is created.
Closed Boolean Determines if the list is closed {archived}.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587