Comments

Lists comments on cards.

Table-Specific Information

Select

The 本製品 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.

ADO.NET Provider for Trello