- Thu Mar 09, 2017 7:15 pm
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.