ReminderNotifications
Controls reminder rules that trigger alerts based on time or conditions, allowing teams to track deadlines or follow-ups more reliably.
Select
The AppId column is required in the WHERE clause. The connector will use the Kintone APIs to filter the results by this column. By default, the connector will process other filters client-side within the connector.
For example, the following queries are processed server side:
SELECT * FROM ReminderNotifications WHERE AppId = 6 SELECT * FROM ReminderNotifications WHERE AppId = 6 AND Lang = 'en' SELECT * FROM ReminderNotifications WHERE AppId = 6 AND IsPreview = false
Update
For updating the ReminderNotifications, provide the Notifications as an aggregate. The AppId column is required to update the ReminderNotifications.
UPDATE ReminderNotifications SET Notifications = '[{"timing":{"code":"Updated_datetime","daysLater":-2,"hoursLater":-5},"filterCond":"Record_number = 14","title":"Reminder: Tomorrow is the deadline.","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 reminder-notification settings are being retrieved or updated. | |
| FilterCond | String | False |
Record filter condition expressed in query-string format, defining which records trigger the reminder notification. | |
| Title | String | False |
Subject line used for the reminder notification, corresponding to the Summary field shown in the Kintone interface. | |
| TimingCode [KEY] | String | False |
Field code of the date or datetime field that determines when the reminder notification should be triggered. | |
| TimingDaysLater | Integer | False |
Number of days offset from the value in the timing field, where positive values schedule the reminder after that date and negative values schedule it before that date. | |
| TimingHoursLater | Integer | False |
Number of hours offset from the timing field's datetime value, applied after the day offset defined by TimingDaysLater. | |
| TimingTime | String | False |
Specific time of day when the reminder notification should be sent, returned when the timing field is a date field or when time-based scheduling is configured. | |
| Targets | String | False |
Array of objects listing the users, groups, or departments that receive the reminder notification. | |
| Revision | String | True |
Revision number of the app settings, helping track changes to the reminder-notification configuration. | |
| Timezone | String | False |
Time zone used to determine when reminder notifications are sent, reflecting the Reminder Time Zone setting and returning null when no reminder configuration exists. |
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 reminder-notification details in a specific language. |
| IsPreview | Boolean |
Indicates whether to retrieve reminder-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 reminder-notification settings. |