Sorry, clicked on 'Send' too quickly...
> > However, my effort is now about to be measured and my boss is
> > looking to see
> > how long it takes me to solve an issue from it has been received.
> > I am struggling to create a script that can to this, so I am
> > asking the
> > community if anyone apart from me have received this requests
> > from their
> > bosses, and how you have handled this.
It should be very simple to create a report on this, since there is
already a date field on the issue table. Consider the following query:
UNIX_TIMESTAMP(iss_created_date) AS time_diff
usr_email='<your email here>' AND
iss_closed_date IS NOT NULL
That should give you what you want. All you really need is to format the
"time_diff" column above with Misc::getFormattedTime(), and the report
p.s.: please note that getFormattedTime() takes the time difference in
minutes, so do Misc::getFormattedTime($time_diff / 60)