RecordPermissionsEntities
Breaks record-level permissions into their detailed entities to show how access rules differ for users, groups, and roles.
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 RecordPermissionsEntities WHERE AppId = 6 SELECT * FROM RecordPermissionsEntities WHERE AppId = 6 AND Lang = 'en' SELECT * FROM RecordPermissionsEntities WHERE AppId = 6 AND IsPreview = false
Columns
| Name | Type | References | Description |
| AppId | Integer | Identifier of the Kintone app whose record-permission entity assignments are being retrieved. | |
| FilterCond | String | Filter condition expressed in query-string format that specifies which records the entity-level permissions apply to. | |
| EntityType | String | Type of entity that receives the record-level permission, such as a user, group, or department. | |
| EntityCode | String | Code identifying the specific entity to which the record-level permission is granted. | |
| Viewable | Boolean | Indicates whether the entity has permission to view records that match the filter condition. | |
| Editable | Boolean | Indicates whether the entity has permission to edit records that match the filter condition. | |
| Deletable | Boolean | Indicates whether the entity has permission to delete records that match the filter condition. | |
| IncludeSubs | Boolean | Indicates whether permissions 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 entity-level record-permission details in a specific language. | |
| IsPreview | Boolean | Indicates whether to retrieve record-permission entity details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |