Mantis Bug Tracker - Forums

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..

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"

Has this query worked, any plugin if you can suggest? I have the exact same requirement

I still have a plugin lying around which does something like requested.
This plugin calculates the number of days between 2 statusses and evaluates that against a set number of days.
Default it will calculate between Confirm date and Resolved date.
Only issues with a date on Resolving are selected.
Next the last confirm date is retrieved.
If not found, it will retrieve the last assign date.
If not found, it will use the date of submittal.
Next these 2 dates are compared and if the period is less or equal than the set number of days (default 2), it will qualify the issue resolved within agreed period.
Output is available on screen and as download.
Output currently is:
Issue-id, Assignee, Date of submittal, Period between Status New and Confirmed,Date of status Confirmed,
Period between Status Confirmed and Resolved, Date of status Resolved, Period between Status New and Resolved On time, Category
See plugin here : https://github.com/mantisbt-plugins/KPI