This topic applies only to the IBM Business Process Manager Advanced configuration.

SHARED_WORK_ITEM view

Use this predefined Business Process Choreographer database view for queries on shared work items. Only system administrators can query this view.

Table 1. Columns in the SHARED_WORK_ITEM view
Column name Type Comments
WSID ID The shared work item pattern ID.
OWNER_ID String The principal ID of the owner.
GROUP_NAME String The name of the associated group worklist.
EVERYBODY Boolean Specifies whether everybody owns this work item.
REASON Integer The reason for the assignment of the work item. This integer value indicates one of the following meanings:

REASON_NONE (0)
REASON_POTENTIAL_OWNER (1)
REASON_EDITOR (2)
REASON_READER (3)
REASON_OWNER (4)
REASON_POTENTIAL_STARTER (5)
REASON_STARTER (6)
REASON_ADMINISTRATOR (7)
REASON_ORIGINATOR (9)
REASON_ESCALATION_RECEIVER (10)
REASON_POTENTIAL_INSTANCE_CREATOR (11)