Show TOC

My Tasks DataSourceLocate this document in the navigation structure

Use

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

Note

For all possible values in fields CATEGORY and STATUS , see SAP Note 1383528 Information published on SAP site.