PerRecordNotificationsTargets
Returns the list of users and groups who receive record-level notifications, supporting communication audits and troubleshooting.
Select
The AppId column is required in the WHERE clause. The server will use the Kintone APIs to filter the results by this column. By default, the server will process other filters client-side within the server.
For example, the following queries are processed server side:
SELECT * FROM PerRecordNotificationsTargets WHERE AppId = 6 SELECT * FROM PerRecordNotificationsTargets WHERE AppId = 6 AND Lang = 'en' SELECT * FROM PerRecordNotificationsTargets WHERE AppId = 6 AND IsPreview = false
Columns
| Name | Type | References | Description |
| AppId | Integer | Identifier of the Kintone app whose per-record notification target settings are being retrieved. | |
| Title | String | Subject line of the per-record notification, matching the Summary text used when the notification is sent. | |
| EntityType | String | Type of entity configured to receive the per-record notification, such as a user, group, or department. | |
| EntityCode | String | Code identifying the specific entity that receives the per-record notification. | |
| IncludeSubs | Boolean | Indicates whether notification rules assigned to a department should also apply to its subordinate departments. |
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 target-setting values in a specific language. | |
| IsPreview | Boolean | Indicates whether to retrieve per-record notification target details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |