Lists all the cards from every board
Table Specific Information
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 Card has been archived or not.
SELECT * FROM Cards
The query above will return all cards found regardless of whether they are archived or not.
SELECT * FROM Cards WHERE Closed='false'
The query above will return all the cards that are not archived.
SELECT * FROM Cards WHERE ListID='4e99eb7aa9797361bc22e6d5' SELECT * FROM Cards WHERE BoardID='4e99eb7aa9797361bc22e6ct' SELECT * FROM Cards WHERE Closed='true'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.
To insert a new Card in table Cards you have to specify a Name and a ListId in the insert statement.
Columns Name, Description, ListID, MemberIds, LabelIds and Due can be used for insert where ListId is.
Columns MemberIds and LabelIds are comma separated list of member/label ids.
Example of inserting a new Card:
INSERT INTO Cards(Name, Description, ListID, MemberIds, LabelIds, Due) VALUES('new Card', 'new card description', 'list_id', 'member_id_1, member_id_2', 'label_id_1,label_id_2', '2019-09-18')
To execute an update to table Cards you have to specify the CardId you are trying to update.
Columns Name, Description, ListID, MemberIds, LabelIds, Due and closed can be updated. Columns MemberIds and LabelIds are comma separated list of member/label ids.
Example of updating all the fields:
UPDATE Cards SET Name='new name', Description='new description', ListID='listId', MemberIds='member_id_1,member_id_2', LabelIds='label_id_1,label_id_2', Due='2019-09-18' WHERE CardID='card_id'
To archive a card you can update its closed property to true for ex:
UPDATE Cards SET Closed='true' WHERE CardID='card_id'
To delete a card you must specify a CardID for ex:
DELETE FROM Cards WHERE CardID='card_id'
The Id of the card
The name of the card
The Id of the board which the card references
The Id of the list which the card references
The Ids of the members assigned to card
The Id of the checklist which the card references
The Ids of the labels assigned to card
The Id of the attachment on the cover of the card
Description of the card
Determines if the card is closed or not
This field returns the due time if it has been assigned to card
Number of total attachments in the card