FieldPermissionsEntities
Breaks field-level permissions into their underlying rules to help you understand exactly how visibility and edit rights differ across users and groups.
Select
WHERE 句ではAppId カラムが必須です。本製品 はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、本製品 はクライアント側で本製品 内で他のフィルタを処理します。
例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM FieldPermissionsEntities WHERE AppId = 6 SELECT * FROM FieldPermissionsEntities WHERE AppId = 6 AND IsPreview = false
Columns
| Name | Type | References | Description |
| AppId [KEY] | Integer | Identifier of the Kintone app whose field-permission assignments are being examined or updated. | |
| Code [KEY] | String | Field code that identifies the specific app field for which detailed entity-level permissions are defined. | |
| EntityType | String | Type of entity receiving the field permission, such as a user, group, or department, allowing you to understand how access is structured across the organization. | |
| EntityCode | String | Code that uniquely identifies the user, group, or department to which the field permission applies. | |
| Accessibility | String | Permission level granted to the entity, indicating whether the entity can view, edit, or is restricted from interacting with the field.
使用できる値は次のとおりです。READ, WRITE, NONE | |
| IncludeSubs | Boolean | Indicates whether field permissions granted to a department should also apply to its subordinate departments, supporting hierarchical access control. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| 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'. |