Comments
Query the available comments in kintone.
Select
The RecordId and AppId columns are required in the WHERE clause. The add-in will use the Kintone APIs to filter the results by these columns. The Kintone APIs also support filters on Id. By default, the add-in will process other filters client-side within the add-in.
For example, the following queries are processed server side:
SELECT * FROM Comments WHERE RecordId = 1 AND AppId = 5 AND Id = 1
Insert
The AppId and RecordId columns are required in the INSERT statement.
INSERT INTO Comments (AppId, RecordId, Text, MentionsAggregate) VALUES (5, 1, 'To do', '[{"code": "Administrator","type": "USER"}]')
Delete
Comments can be deleted by issuing a DELETE statement and specifying the RecordId, AppId, and Id.
DELETE FROM Comments WHERE RecordId = 1 AND AppId = 5 AND Id = 1
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The Comment Id. | |
| AppId [KEY] | Integer | False |
The App Id. | |
| RecordId [KEY] | Integer | False |
The Record Id. | |
| Text | String | False |
The comment including the line feed codes. | |
| CreatorCode | String | True |
The user code of the comment creator (log-in name). | |
| CreatorName | String | True |
The user name of the comment creator (display name). | |
| CreatedAt | Datetime | True |
The created date and time of the comment. | |
| MentionsAggregate | String | False |
An array including information of mentioned users. |