You can't do this with Report Tables, but you can create a custom PM Table and then use triggers to write to that PM Table.
First create a PM Table named "PARALLEL_DATA", with the following fields:
CASE_ID (char with length 32)
USER_ID (char with length 32)
USERNAME (varchar with length 64)
[any additional data fields filled in your parallel task]
Then, add the following trigger to your process:
Code: Select all
$taskId = @@TASK;
$caseId = @@APPLICATION;
$caseNo = @@APP_NUMBER;
$userId = @@USER_LOGGED;
$username = @@USR_USERNAME;
$sql = "SELECT COUNT(*) AS COUNT FROM APP_DELEGATION WHERE
APP_UID='$caseId' AND TAS_UID='$taskId' AND DEL_THREAD_STATUS = 'CLOSED'";
$result = executeQuery($sql);
$count = $result['COUNT'] + 1;
$sql = "INSERT INTO PMT_PARALLEL_DATA (CASE_ID, CASE_NO, DATE_EXECUTED, USER_ID, USERNAME, COUNT)
VALUES ('$caseId', $caseNo, NOW(), '$userId', '$username', $count)";
Set your trigger to execute before assignment in your parallel task.
Another way to do this is simply query the APP_CACHE_VIEW table in the database, and sort the results by the DEL_FINISH_DATE.