PerRecordNotificationsTargets
Query the PerRecord Notifications Targets in kintone.
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 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 | The App ID of the kintone application. | |
| Title | String | The notification subject that is saved under Summary. | |
| EntityType | String | The type of the entity the Per Record Notification settings are configured to. | |
| EntityCode | String | The code of the entity the Per Record Notification settings are configured to. | |
| IncludeSubs | Boolean | The Include affiliated departments setting of the Department. |
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 | The localized language to retrieve the data. | |
| IsPreview | Boolean | By setting this to False, you will be able to retrieve the PerRecord Notifications Targets details of the live App. Default value is true. |