Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Is there possible to set the estimated task time duration in (events->Intermediate message->edit event) dynamically by using date fields? in processmaker 2.5
Here I attached where to set the timings by using date field variable @@due date.
(112.33 KiB) Downloaded 79 times
It is not possible in the definition of the event, but you can create a trigger in the task which uses executeQuery() to look up all the pending events and checks to see whether they should have a custom time setting. If so, use an UPDATE statement with executeQuery() to changes the estimate task duration in the database. I don't have version 2.5 installed, so I can't remember the exact table name and field name but if you look in the database with phpmyadmin you can find the table where events are stored for each case and change the time. The problem is that you can only change the time after the event has started, which means that you have to create an external script which periodically calls the executeTrigger() web service to execute your trigger. Set your external script to automatically execute as a cron job in Linux or a Scheduled Task in Windows.

It is working. Thanks a lot.

Hi, I saw an old topic in this forum with this err[…]

Grid, difference between 2 dates

Hello, You could use this code instead of yours: […]

hello, I have one dynaform with grid. In grid the[…]