JDBC Driver for Kintone

Build 22.0.8462

Comments

Query the available comments in kintone.

Select

The RecordId and AppId columns are required in the WHERE clause. The driver will use the Kintone APIs to filter the results by these columns. The Kintone APIs also support filters on Id. By default, the driver will process other filters client-side within the driver. If SupportEnhancedSQL is set to false, an error will be returned for filters on other columns.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462