ProcessManagement
Controls the workflow rules that govern how records move through states, allowing administrators to manage process steps, transitions, and restrictions.
Select
WHERE 句ではAppId カラムが必須です。本製品 はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、本製品 はクライアント側で本製品 内で他のフィルタを処理します。
例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM ProcessManagement WHERE AppId = 6 SELECT * FROM ProcessManagement WHERE AppId = 6 AND Lang = 'en' SELECT * FROM ProcessManagement WHERE AppId = 6 AND IsPreview = false
Update
ProcessManagement を更新するには、States とActions を集計として指定します。ProcessManagement を更新するには、AppId カラムが必須です。
UPDATE ProcessManagement SET Enable = true, States = '{"In progress":{"name":"In progress","index":"1","assignee":{"type":"ONE","entities":[]}},"Ready":{"name":"Ready","index":"3","assignee":{"type":"ONE","entities":[]}},"Completed":{"name":"Completed","index":"2","assignee":{"type":"ONE","entities":[]}},"Not started":{"name":"Not started","index":"0","assignee":{"type":"ONE","entities":[{"entity":{"type":"FIELD_ENTITY","code":"Created_by"},"includeSubs":false}]}}}', Actions = '[{"name":"Start","from":"Not started","to":"In progress","filterCond":""},{"name":"Complete","from":"Completed","to":"Completed","filterCond":""}]' WHERE AppId = 6
Columns
| Name | Type | ReadOnly | References | Description |
| AppId [KEY] | Integer | False |
Identifier of the Kintone app whose process-management configuration is being retrieved or updated. | |
| Enable | Boolean | False |
Indicates whether process management is enabled for the app, controlling whether records progress through defined workflow states. | |
| Actions | String | False |
Array containing the app's process-management actions in the same order shown in the user interface, with the value of 'null' returned when process management has never been enabled. | |
| Revision | String | True |
Revision number of the app settings, helping track updates made to the process-management configuration. | |
| Name | String | False |
Display name of the workflow status associated with the current process-management state. | |
| Index | String | False |
Ascending display order of the workflow status, determining its position relative to other statuses. | |
| AssigneeType | String | False |
Type of assignee list used for the status, defining how users or groups are selected to handle the workflow step. | |
| AssigneeEntities | String | False |
Array listing the assignees configured for the status, returned in the same order presented in the user interface. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| Lang | String |
Locale code used to retrieve process-management details in a specific language. |
| IsPreview | Boolean |
Indicates whether to retrieve process-management details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |
| States | String |
Value used only when performing an update to supply modified process-management state definitions. |