PerRecordNotifications
Maintains notification rules tied to individual records, helping you automate alerts based on deadlines, conditions, or workflow changes.
Select
The AppId column is required in the WHERE clause. The driver will use the Kintone APIs to filter the results by this column. By default, the driver will process other filters client-side within the driver.
For example, the following queries are processed server side:
SELECT * FROM PerRecordNotifications WHERE AppId = 6 SELECT * FROM PerRecordNotifications WHERE AppId = 6 AND Lang = 'en' SELECT * FROM PerRecordNotifications WHERE AppId = 6 AND IsPreview = false
Update
For updating the PerRecordNotifications, provide the Notifications as an aggregate. The AppId column is required to update the PerRecordNotifications.
UPDATE PerRecordNotifications SET Notifications = '[{"filterCond":"Record_number = 18","title":"Test Title","targets":[{"entity":{"type":"FIELD_ENTITY","code":"Created_by"},"includeSubs":false}]}]' WHERE AppId = 6
Columns
| Name | Type | ReadOnly | References | Description |
| AppId [KEY] | Integer | False |
Identifier of the Kintone app whose per-record notification settings are being retrieved or updated. | |
| FilterCond | String | False |
Record filter condition expressed in query-string format, defining which records trigger the per-record notification. | |
| Title [KEY] | String | False |
Subject line used for the notification, corresponding to the Summary field that appears in the Kintone interface. | |
| Targets | String | False |
Array of objects listing the users, groups, or departments that receives the per-record notification. | |
| Revision | String | True |
Revision number of the app settings, helping track updates made to the notification configuration. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Lang | String |
Locale code used to retrieve per-record notification data in a specific language. |
| IsPreview | Boolean |
Indicates whether to retrieve per-record 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 per-record notification settings. |