Process choreographer provides the following predefined view for queries on work items. Only the columns that are relevant to V5.0-style processes are documented here.
Column name | Type | Comments |
---|---|---|
WIID | ID | Work item ID. |
OWNER_ID | String | Principal ID of the owner. |
GROUP_NAME | String | The name of the associated group worklist. |
EVERYBODY | Boolean | Flag indicating whether everybody owns this work item. |
OBJECT_TYPE | Integer | Type of the associated object. Possible
values:OBJECT_TYPE_ACTIVITY OBJECT_TYPE_PROCESS_INSTANCE OBJECT_TYPE_EVENT |
OBJECT_ID | ID | ID of the associated object, for example, the associated process or activity. |
ASSOC_OBJECT_TYPE | Integer | Type of object associated with, or containing,
the associated object of the work item. Possible values:OBJECT_TYPE_ACTIVITY OBJECT_TYPE_PROCESS_INSTANCE OBJECT_TYPE_EVENT |
ASSOC_OID | ID | ID of the object associated with, or containing, the associated object of the work item. For example, the process instance ID (PIID) of the process instance containing the activity instance for which this work item was created. |
REASON | Integer | The reason that the work item was assigned.
Possible values:REASON_POTENTIAL_OWNER REASON_EDITOR REASON_READER REASON_OWNER REASON_POTENTIAL_STARTER REASON_STARTER REASON_ADMINISTRATOR |