Comments
Create, update, delete, and query Comments associated with a Note or Email and visible to the authenticated user.
Table Specific Information
Select
To retrieve Comments, provide a SubjectType that the Note belongs to, such as Notes or Emails, and the Subject Id.
SELECT * FROM Comments WHERE SubjectType = 'notes' AND SubjectId = '351922361'
Insert
The following query inserts a Comment. At least the Comment Body and ParentId must be provided.
INSERT INTO Comments (Body, ParentId) VALUES ('me comment', '351199012')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the comment. | |
| Body | String | False |
The body of the comment. | |
| ParentId | Integer | False |
The Id of the parent of the comment. | |
| SubjectId | Integer | True |
The Id of the subject of the comment. | |
| SubjectType | String | True |
The subject type of the comment. | |
| SubjectName | String | True |
The subject name of the comment. | |
| CollectionId | Integer | True |
The Id of the collection. | |
| CollectionType | String | True |
The type of the collection. | |
| VisibleTo | String | True |
Who the comment is visible to: Everyone, Owner, or NamedGroup. | |
| GroupId | Integer | True |
The Id of the group. | |
| OwnerId | Integer | True |
The Id of the owner. | |
| AuthorId | Integer | True |
The Id of the author of the comment. | |
| CreatedAt | Datetime | True |
The date and time when the comment was created. | |
| UpdatedAt | Datetime | True |
The date and time when the comment was last updated. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ParentType | String |
Whether the comment is associated with a note or email. The allowed values are note, email. The default value is note. |