ODBC Driver for Trello

Build 20.0.7587

CheckListItems

Lists all items found on checklists.

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 CheckListItems

SELECT * FROM CheckListItems WHERE CheckListId='58e2018031e2b8e881b89b4g'

SELECT * FROM CheckListItems WHERE CardId='58e34da8446e578ac1bbb03b'
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
CheckListItemId [KEY] String The Id of the item.
CheckListId String The Id of the checklist.
Name String The name of the item.
State String The state of the item.
CardID String The Id of the card referencing 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