WORK_ITEM view

Use this predefined database view for queries on work items and authorization data for process, tasks, and escalations.

Table 1. Columns in the WORK_ITEM view
Column name Type Comments
WIID ID The work item 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.
OBJECT_TYPE Integer The type of the associated object. Possible values are:
OBJECT_TYPE_ACTIVITY
Specifies that the work item was created for an activity.
OBJECT_TYPE_PROCESS_INSTANCE
Specifies that the work item was created for a process instance.
OBJECT_TYPE_TASK_INSTANCE
Specifies that the work item was created for a task.
OBJECT_TYPE_TASK_TEMPLATE
Specifies that the work item was created for a task template.
OBJECT_TYPE_ESCALATION_INSTANCE
Specifies that the work item was created for an escalation instance.
OBJECT_TYPE_APPLICATION_COMPONENT
Specifies that the work item was created for an application component.
OBJECT_ID ID The ID of the associated object, for example, the associated process or task.
ASSOC_OBJECT_TYPE Integer The type of the object referenced by the ASSOC_OID attribute, for example, task, process, or external objects. Use the values for the OBJECT_TYPE attribute.
ASSOC_OID ID The ID of the object associated object with 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 for the assignment of the work item. Possible values are:

REASON_POTENTIAL_STARTER
REASON_POTENTIAL_INSTANCE_CREATOR
REASON_POTENTIAL_OWNER
REASON_EDITOR
REASON_READER
REASON_ORIGINATOR
REASON_OWNER
REASON_STARTER
REASON_ESCALATION_RECEIVER
REASON_ADMINISTRATOR

CREATION_TIME Timestamp The date and time when the work item was created.

Terms of use | | Broken links

Last updated: Mon Mar 27 18:04:05 2006

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)