GeneralNotifications
Controls global notification settings for an app, allowing you to adjust how users are alerted about updates, mentions, or record activity.
Select
WHERE 句ではAppId カラムが必須です。connector はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、connector はクライアント側でconnector 内で他のフィルタを処理します。
例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM GeneralNotifications WHERE AppId = 6 SELECT * FROM GeneralNotifications WHERE AppId = 6 AND IsPreview = false
Update
GeneralNotifications を更新するには、Notifications を集計として指定します。GeneralNotifications を更新するには、AppId カラムが必須です。
UPDATE GeneralNotifications SET Notifications = '[{"entity":{"type":"FIELD_ENTITY","code":"Updated_by"},"includeSubs":false,"recordAdded":false,"commentAdded":true}],"notifyToCommenter":true' WHERE AppId = 6
Columns
| Name | Type | ReadOnly | References | Description |
| AppId [KEY] | Integer | False |
Identifier of the Kintone app whose general notification settings are being retrieved or updated. | |
| EntityType | String | False |
Type of entity that receives the general notifications, such as a user, group, or department. | |
| EntityCode [KEY] | String | False |
Code identifying the specific entity configured to receive general notifications. | |
| IncludeSubs | Boolean | False |
Indicates whether notification rules assigned to a department should also apply to its subordinate departments, and always returns 'false' unless notifications[].entity.type is set to ORGANIZATION or FIELD_ENTITY for a Department Selection field. | |
| RecordAdded | Boolean | False |
Specifies whether the entity should receive a notification whenever a new record is added to the app. | |
| RecordEdited | Boolean | False |
Specifies whether the entity should receive a notification when an existing record is edited. | |
| CommentAdded | Boolean | False |
Specifies whether the entity should receive a notification when a new comment is posted on a record. | |
| StatusChanged | Boolean | False |
Specifies whether the entity should receive a notification when a record's status changes within a workflow. | |
| FileImported | Boolean | False |
Specifies whether the entity should receive a notification when data is imported into the app using a file. | |
| NotifyToCommenter | Boolean | False |
Specifies whether all commenters on a record should be notified when a new comment is added, reflecting the Send updated comment notifications to all commenters setting. | |
| Revision | String | True |
Revision number of the app settings, helping track changes made to notification rules. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| IsPreview | Boolean |
Indicates whether to retrieve general-notification details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |
| Notifications | String |
Value used only when performing an update to supply modified general-notification settings.. |