Calculating total time spent on resolving an incoming query

Discuss your general Proclaim related queries here.
Post Reply
Procomplete
Posts: 1
Joined: Wed Dec 19, 2018 10:00 am

Calculating total time spent on resolving an incoming query

Post by Procomplete » Wed Dec 19, 2018 11:14 am

I’m exploring ways to calculate the TOTAL time spent resolving a query on a case. The query may involve multiple actions in the history to various different correspondents that need adding together to provide the total time spent resolving the query.
Eg these 4 separate actions would appear in the history of a case and I need to calculate the total hrs/days from the start point to the end point.

1. IM solicitor emails to chase a report = start point
2. MC Make call to chase medical expert for report
3. TC Expert calls to provide explanation for delay
4. MC Make call to solicitor to update them on the delayed report = query complete

You cannot use a simple FETCH from the history because there is no unique code to link the actions as “related” plus
There may be more than one query ongoing at any one time on a case. ?

Has anyone successfully achieved anything along these lines or suggestions to try?

revellbikes
Posts: 432
Joined: Fri Jun 15, 2012 12:44 pm
Has thanked: 12 times
Been thanked: 43 times

Re: Calculating total time spent on resolving an incoming query

Post by revellbikes » Thu Dec 20, 2018 2:46 pm

There's nothing hard coded to link them no, but surely you could create some code to pick out start and end date and time with the fetch command and then calculate the number of seconds, minutes, days, years... between the two?

Post Reply