[springhigh]

Hi there
I'm trying to figure out how to put Task Labels into a report table.
To better show in reports, where each case is in the process
i.e.
Case 1 / Task one
Case 2 / Task three
Case 3 / Task One
et..

Any ideas on how this can be done would be welcome

[mishika]

Hello,

To achieve this you can do the following:
1. Create a variable for task label say @@tasklabel.
2. Write a trigger which gets the value of task label for the corresponding Task ID(@@TASK), from the database (table TASK)
3. Store the variable @@tasklabel in your report table.

The trigger to get the value of @@tasklabel can be as follows:

Code: Select all

$taskid = @@TASK;
$query = "SELECT TAS_TITLE FROM TASK WHERE TAS_UID = '$taskid'";
@@res = executeQuery($query);
@@tasklabel = @@res[1]['TAS_TITLE'];

As and when you start a case, an entry will be created in the report table with the value of @@tasklabel as the label of the first task.
When the process will be routed to the next task, @@tasklabel will be overwritten by the label of the second task and so on.

Hope this helps

Best Regards
Mishika

[springhigh]

Thank Mishika

With Advanced Reports, could the TASK Table be added to whiteTablesList.ini to achieve this ?
I'm looking for a way to join a Pmt with TASK_TAS_TITLE

[mishika]

Hello,

Yes, you can do this in Advanced Reports.
You can add the TASK table in the whiteTablesList.ini file. The PMT tables will be included by default
Also, you need to include the fields from the tables that you require in the file variablesConfig.ini

After this, you can follow the procedure to create a report with a report scope where you can use these tables and their fields and create a join as desired.
For the procedure you can refer the following link:
http://wiki.processmaker.com/3.1/Data_R ... ore_Report

Hope this helps

Best Regards
Mishika

[springhigh]

Thank Mishika , both solutions great

[frednjiru]

Mishika

Thanks for the above procedure, but how can i make it fetch the next task?
currently its picking the current task.