Comments
Lists comments on cards.
Table-Specific Information
Select
The server pushes supported filters in the WHERE clause to the Trello API. Remaining filters are applied client-side in the driver. For example, the following query is processed server-side:
SELECT * FROM Comments WHERE CardID = '62e96e528866a54d28ae516a'
Insert
Use INSERT statements to create new records in this table.
INSERT INTO Comments (CardID, Comment) VALUES ('62e96e528866a54d28ae516a', 'test');
INSERT INTO Comments (CardID, Comment) VALUES ('62e96e528866a54d28ae516a', 'This is a detailed comment about the task progress');
Update
Use UPDATE statements to modify existing records in this table.
UPDATE Comments SET Comment = 'Updated comment text' WHERE CommentId = 'comment_id_here' AND CardID = '62e96e528866a54d28ae516a';
Delete
Use DELETE statements to remove records from this table.
DELETE FROM Comments WHERE CommentId = 'comment_id_here';
Columns
| Name | Type | ReadOnly | Description |
| CommentId [KEY] | String | True |
The Id of the action. |
| Type | String | True |
The action type (possible values https://developers.trello.com/reference#action-types). |
| Date | Datetime | True |
Date created. |
| BoardID | String | True |
The Id of the board which the action references. |
| ListName | String | True |
The name of the list which the action references. |
| ListID | String | True |
The Id of the list which the action references. |
| CardID [KEY] | String | False |
The Id of the card which the action references. |
| CardName | String | True |
The name of the card which the action references. |
| CardShortLink | String | True |
The link of the card which the action references. |
| MemberId | String | True |
The Id of the member associated with the action. |
| MemberName | String | True |
The name of the member associated with the action. |
| OldPosition | String | True |
The old position of the card when you move it up or down inside a list. |
| ListAfterId | String | True |
The old position of the card when you move it up or down inside a list. |
| ListBeforeId | String | True |
The old position of the card when you move it up or down inside a list. |
| OrganizationID | String | True |
The Id of the organization which the comment references. |
| Comment | String | False |
The comment body if the action is of type commentCard. |
| CreatedDate | Datetime | True |
The time the action was created. |