RecordPermissionsEntities
Query the available Record Permissions Entities in kintone.
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 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 | The App ID of the kintone application. | |
| FilterCond | String | The filter condition of the record permission. | |
| EntityType | String | The type of the entity the permission is granted to. | |
| EntityCode | String | The code of the entity the permission is granted to. | |
| Viewable | Boolean | The view permission of the entity. | |
| Editable | Boolean | The edit permission of the entity. | |
| Deletable | Boolean | The delete permission of the entity. | |
| IncludeSubs | Boolean | The permission inheritance settings of the department the permission is granted to. |
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 Record Permissions Entities details of the live App. Default value is true. |