Hi Folks, Our management is adamant about having time tracked automatically on tickets.
I've been banging my head against a wall for 2 months trying to get this to work VIA pure SQL until I realized that the data model seems to not support it. Specifically although there's a transaction logged every time the ticket goes from open to stalled back to opened, there's no idea of a transaction session so that if I try to write SQL that joins transaction to transaction, and tries to subtract the latest time stamp for "opened" from the last "opened" there's no way to determine which two "Opened" transactions corelate to the transaction before it, so it ends up double counting (imagine a ticket that goes from Opened, to Stalled, to Opened, to Stalled and so-on), I end up having subtracting all latest records from the original record so it double counts. So I've tried to use the Scrips to do this, and noticed there's already a user-contributed Scrip for "SetTimeWorkedAutomatically": https://rt-wiki.bestpractical.com/wiki/SetTimeWorkedAutomatically However I can't get this to work on my version of RT. First off, when I go to create a Scrip there's no option for "Custom action cleanup code". I only get 3x options for creating a Scrip: "Custom Condition" "Custom Action Preparation Code" and "Custom Action Commit Code" ... I've tried pasting the perl script that's on the above URL into any of the 3x fields but RT errors and fails to compile the Scrip. So I then tried to create a custom action with little success. I can provide my code for the custom action. Can anyone help out with this? -- View this message in context: http://requesttracker.8502.n7.nabble.com/Getting-SetTimeWorkedAutomatically-Working-in-RT-4-2-9-tp62258.html Sent from the Request Tracker - User mailing list archive at Nabble.com. --------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Los Angeles - September, 2016
