My Processes DataSource
Technical name: BPM_MY_PROCESSES_DS
|
Field Name |
Description |
Type |
|---|---|---|
|
ID |
Process 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 (for sub-processes) |
VARCHAR |
|
PRIORITY |
Process instance priority |
SMALLINT |
|
STATUS |
Process instance status: IN_PROGRESS, COMPLETED, and so on |
VARCHAR |
|
IN_ERROR |
Process instance 'in error flag': t (true) or f (false) |
BIT |
|
IS_ESCALATED |
Process instance 'is escalated' flag: t (true) or f (false) |
BIT |
|
START_TIME_D |
Process start date |
DATE |
|
START_TIME_T |
Process start time |
TIME |
|
START_TIME |
Process start time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
|
END_TIME_D |
Process completion date |
DATE |
|
END_TIME_T |
Process completion time |
TIME |
|
END_TIME |
Process completion time in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
|
INITIATOR_ID |
Initiator (principal) unique ID |
VARCHAR |
|
INITIATOR_NAME |
Initiator (principal) name |
VARCHAR |
|
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 |
Process instance name |
VARCHAR |
|
DESCRIPTION |
Process instance description |
VARCHAR |
|
DURATION_MILLIS |
Overall process duration in milliseconds |
BIGINT |
The following filters are supported:
-
Date range filter (BETWEEN operator) for date fields START_TIME_D, END_TIME_D, LAST_MODIFIED_D
ExampleSTART_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, PRIORITY, STATUS, IN_ERROR, IS_ESCALATED
ExampleID = BC090000369911DFC26400000068106E
This single value filter selects the specific process instance.
ExampleSTATUS = IN_PROGRESS; COMPLETED;
This multiple values filter selects all process instances with status In progress or Completed .
-
Single value filter for either ROOT_ID or PARENT_ID fields
For all possible values in field
STATUS , see SAP Note
1383528 
.