Comments

Query the available comments in kintone.

Select

The RecordId and AppId columns are required in the WHERE clause. The cmdlet will use the Kintone APIs to filter the results by these columns. The Kintone APIs also support filters on Id. By default, the cmdlet will process other filters client-side within the cmdlet.

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.

Cmdlets for Kintone

Comments

Select

Insert

Delete

Columns