FieldPermissions
Manages fine-grained access rules for individual fields so administrators can enforce data visibility and edit restrictions at the field level.
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 FieldPermissions WHERE AppId = 6 SELECT * FROM FieldPermissions WHERE AppId = 6 AND IsPreview = false
Update
For updating the FieldPermissions, provide the Rights as an aggregate. The AppId and IsPreview columns are required to update the FieldPermissions.
UPDATE FieldPermissions SET Rights = 'Update FieldPermissions set Rights='[{"code":"Updated_by","entities":[{"accessibility":"READ","entity":{"type":"GROUP","code":"everyone"}}]}]' WHERE AppId = 6 AND IsPreview = true
Columns
| Name | Type | ReadOnly | References | Description |
| AppId [KEY] | Integer | False |
Identifier of the Kintone app whose field-level permission settings are being retrieved or updated. | |
| Code [KEY] | String | False |
Field code identifying the specific field that has custom permission rules applied. | |
| Entities | String | False |
Array listing the users, groups, or departments that receive field-level permissions, ordered by priority to control how permissions are evaluated. | |
| Revision | String | True |
Revision number of the app settings, helping track updates to field-permission configurations. |
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 |
| IsPreview | Boolean |
Indicates whether to retrieve field-permission details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |
| Rights | String |
Value used only when performing an update to supply modified field-permission settings. |