Technical name: BPM_MY_TASKS_DS
Field Name |
Description |
Type |
---|---|---|
ID |
Task instance unique ID |
VARCHAR |
ROOT_ID |
Root process instance ID |
VARCHAR |
PARENT_ID |
Parent Process instance ID |
VARCHAR |
DEF_VERSION_ID |
Definition (version) unique ID |
VARCHAR |
ACTIVITY_ID |
Activity MOF ID |
VARCHAR |
CATEGORY |
Task Category: BUSINESS_TASK, OFFLINE_TASK, and so on |
VARCHAR |
PRIORITY |
Task instance priority |
SMALLINT |
STATUS |
Task instance status: IN_PROGRESS, COMPLETED, and so on |
VARCHAR |
IS_ASSIGNED |
Task instance ‘is assigned’ flag: t (true) or f (false) |
BIT |
IS_SUSPENDED |
Task instance ‘is suspended’ flag: t (true) or f (false) |
BIT |
IN_ERROR |
Task instance ‘in error flag’: t (true) or f (false) |
BIT |
IS_ESCALATED |
Task instance ‘is escalated’ flag: t (true) or f (false) |
BIT |
CREATED_TIME_D |
Task creation date |
DATE |
CREATED_TIME_T |
Task creation time |
TIME |
CREATED_TIME |
Task creation time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
ACTIVATED_TIME_D |
Task activation date |
DATE |
ACTIVATED_TIME_T |
Task activation time |
TIME |
ACTIVATED_TIME |
Task activation time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
STARTED_TIME_D |
Task start date |
DATE |
STARTED_TIME_T |
Task start time |
TIME |
STARTED_TIME |
Task start time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
COMPLETED_TIME_D |
Task completion date |
DATE |
COMPLETED_TIME_T |
Task completion time |
TIME |
COMPLETED_TIME |
Task completion time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
START_DEADLINE_D |
Task start deadline date |
DATE |
START_DEADLINE_T |
Task start deadline time |
TIME |
START_DEADLINE |
Task start deadline time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
COMPL_DEADLINE_D |
Task completion deadline date |
DATE |
COMPL_DEADLINE_T |
Task completion deadline time |
TIME |
COMPL_DEADLINE |
Task completion deadline time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
ACTIV_TIME_D |
Task activation due date |
DATE |
ACTIV_TIME_T |
Task activation due time |
TIME |
ACTIV_TIME |
Task activation due time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
EXPIR_TIME_D |
Task expiration date |
DATE |
EXPIR_TIME_T |
Task expiration time |
TIME |
EXPIR_TIME |
Task expiration time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
LAST_MODIFIED_D |
Date of last update |
DATE |
LAST_MODIFIED_T |
Time of last update |
TIME |
LAST_MODIFIED |
Time of last update in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
SUBJECT |
Task instance name |
VARCHAR |
DESCRIPTION |
Task instance description |
VARCHAR |
WAIT_TIME |
The time in milliseconds taken from the moment the task is ready to be processed until it is claimed by the user |
BIGINT |
PROCESSING_TIME |
The time in milliseconds taken from the moment the task is claimed by the user until it is completed |
BIGINT |
OVERALL_DURATION |
The time in milliseconds taken from the moment the task is ready to be processed until it is completed by the user |
BIGINT |
START_DELAY |
The delay in milliseconds from the start deadline |
BIGINT |
END_DELAY |
The delay in milliseconds from the completion deadline |
BIGINT |
The following filters are supported:
Date range filter (BETWEEN operator) for date fields CREATED_TIME_D, ACTIVATED_TIME_D, STARTED_TIME_D, COMPLETED_TIME_D, START_DEADLINE_D, COMPL_DEADLINE_D, ACTIV_TIME_D, EXPIR_TIME_D, LAST_MODIFIED_D
Example
STARTED_TIME_D = 3/23/10 – 3/24/10
The date format depends on your locale. The single or multiple values operator is not supported for dates. If you want to filter for a specific day, you have to set a range with the day date as min and max boundary, such as 1/1/10 – 1/1/10.
Single (EQUALS) or multiple (IN (...)) values filter for fields ID, DEF_VERSION_ID, ACTIVITY_ID, CATEGORY, PRIORITY, STATUS, IS_ASSIGNED, IS_SUSPENDED, IN_ERROR, IS_ESCALATED
Example
ID = C23F0F4E369911DFCCAD00000068106E; D7C05BBB369911DFB73400000068106E;
This multiple values filter selects the task instances with IDs C23F0F4E369911DFCCAD00000068106E and D7C05BBB369911DFB73400000068106E.
Single value filter for either ROOT_ID or PARENT_ID fields
Example
PARENT_ID = C07EF8C6369911DFBE2500000068106E
This single value filter selects the task instances having the PARENT_ID equal to C07EF8C6369911DFBE2500000068106E