Lists all labels assigned to each card.

Table-Specific Information

Select

The adapter 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 adapter. For example, the following query is processed server-side:

SELECT * FROM CardLabels WHERE CardId = '5cd4655f9c12a516f688b296'

Insert

Use INSERT statements to assign an existing label to a card.

INSERT INTO CardLabels (CardID, LabelId) VALUES ('5cd4655f9c12a516f688b296', '60f96e9adfd5a24d9c5d6bfc');

Delete

Use DELETE statements to remove a label from a card.

DELETE FROM CardLabels WHERE CardID = '5cd4655f9c12a516f688b296' AND LabelId = '60f96e9adfd5a24d9c5d6bfc';

Columns