ODBC Driver for Trello

Build 20.0.7587

Checklists

Lists all checklists found 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:

SELECT * FROM CheckLists

SELECT * FROM CheckLists WHERE CardId='58e34da8446e578ac1bbb03b'

SELECT * FROM CheckLists WHERE BoardID='58e2018031e2b8e881b89b4g'
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
ChecklistId [KEY] String The Id of the checklist.
Name String The name of the checklist.
CardID String The Id of the card with the checklist.
BoardID String The Id of the board referencing the card with the checklist

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