Comments
Create, update, delete, and query Comments associated with a Note or Email and visible to the authenticated user.
テーブル固有の情報
Select
Comments の取得には、Notes およびEmails などのNote が所属するSebjectType およびSubject Id を入力します。
SELECT * FROM Comments WHERE SubjectType = 'notes' AND SubjectId = '351922361'
Insert
Comment の挿入には、次のクエリを入力します。Common Body およびParentId は必須です。
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ParentType | String |
Whether the comment is associated with a note or email. 使用できる値は次のとおりです。note, email デフォルト値はnoteです。 |