ProcessManagement
Update and Query the Process Management 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 ProcessManagement WHERE AppId = 6 SELECT * FROM ProcessManagement WHERE AppId = 6 AND Lang = 'en' SELECT * FROM ProcessManagement WHERE AppId = 6 AND IsPreview = false
Update
For updating the ProcessManagement, provide the States and Actions as an aggregate. The AppId column is required to update the ProcessManagement.
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 |
The App ID of the kintone application. | |
| Enable | Boolean | False |
The on/off settings of the process management settings. | |
| Actions | String | False |
An array containing data of the Actions. They are listed in the same order as in the GUI. Null is returned for Apps that have never enabled the process management settings before. | |
| Revision | String | True |
The revision number of the App settings. | |
| Name | String | False |
The status name. | |
| Index | String | False |
The display order (ascending) of the Status, when listed with the other statuses. | |
| AssigneeType | String | False |
The Assignee List type of the Status. | |
| AssigneeEntities | String | False |
An array listing data of the Assignees. They are listed in the same order as in the GUI. |
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 Process Management details of the live App. Default value is true. |
| States | String |
Only used for performing Update. |