Principal Assignment DataSource

Use

Technical name: BPM_PRINCIPAL_ASSIGNMENT_DS

Field Name	Description	Type
REFERENCE_ID	Unique ID of the process or task instance	VARCHAR
REFERENCE_TYPE	Instance type: PROCESS or TASK	VARCHAR
ROLE_TYPE	Role type: PROCESS_INITIATOR, TASK_INVOLVED, and so on	VARCHAR
PRINCIPAL_ID	Principal unique ID	VARCHAR
PRINCIPAL_NAME	Principal unique 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

The following filters are supported:

Date range filter (BETWEEN operator) for date field LAST_MODIFIED_D

Example

OCCURRENCE_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. End of the example.
Single (EQUALS) or multiple (IN (...)) values filter for fields REFERENCE_ID, REFERENCE_TYPE, ROLE_TYPE, PRINCIPAL_ID and PRINCIPAL_NAME

Example

REFERENCE_TYPE = PROCESS; TASK;

This multiple values filter selects all assignments with reference type equal to PROCESS or TASK.