CardChecklists
Lists all checklists that have been created.
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 CardCheckLists WHERE BoardId = '4e99eb7aa9897361bc22e6ce'
SELECT * FROM CardCheckLists WHERE CardId = '5cd4655f9c12a516f688b296'
Insert
Use INSERT statements to create new records in this table.
INSERT INTO CardCheckLists (CardId, Name, Position) VALUES ('670ceed283e166d0dc3cc31e', 'checklist-insert-test-top-position', 1);
INSERT INTO CardCheckLists (CardId, Name) VALUES ('62e96e528866a54d28ae516a', 'New Checklist');
Delete
Use DELETE statements to remove records from this table.
DELETE FROM CardChecklists WHERE ChecklistId = '6706abfb8e845e8fbf';
Columns
| Name | Type | ReadOnly | Description |
| CheckListId [KEY] | String | True |
The Id of the checklist. |
| Name | String | False |
The name of the checklist. |
| Position | Double | False |
The position of the checklist. |
| CardID | String | False |
The Id of the card with the checklist. |
| BoardID | String | True |
The Id of the board referencing the card with the checklist. |