Response & Resolution time metrics

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
mandarponkshe
Posts: 1
Joined: Aug 25, 2008 3:36 am

Response & Resolution time metrics

Post by mandarponkshe » Aug 25, 2008 7:37 am

I would like to get response time and resolution time reports from Mantis. My requirement is little more elaborate (like get the data by severity, month, etc.); however other requirements are not that important for this query.
By Response time, I mean time difference in minutes between issue creation and issue assignment.
By Resolution time, I mean time difference in minutes between issue assignment and issue closure.

Any thoughts, suggestions in getting this information would be very useful. Thanks..

dyawlak
Posts: 66
Joined: Dec 07, 2007 11:42 am

Re: Response & Resolution time metrics

Post by dyawlak » Oct 14, 2008 7:57 am

I have written a reporting system in Paradox to do just this.

You have to be good at SQL but basically the query looks something like :

select bug.id, bug."project_id", bug."date_submitted", history."date_modified", custom."value" as "Ref"
from mantis_bug_table bug
left join mantis_bug_history_table history
ON (history."bug_id" = bug."id" AND
history."field_name" = 'status' AND
history."new_value" = '90')

left join mantis_custom_field_string_table custom
ON (custom."bug_id" = bug."id" AND custom."field_id" = 3),

mantis_user_table users
where
(users."id" = bug."handler_id" AND users."access_level" = 60) AND
(bug."date_submitted" >= ~s_from and bug."date_submitted"<=~s_to)

order by bug.id, custom."value"

Post Reply