finding reopen issues

[msq]

Hi,

I am doing some quality analysis of issues reported in my project in Mantis.

I want to find all the issues which are reopened once in their life cycle. ( Current status might be fixed or closed or reopened). Is there any way to find it out?

Thanks,
S H

[atrol]

There is no way to get this via standard filtering mechanism of MantisBT.

The information for this can be found in database table mantis_bug_history_table.
Search for bug_id where field_name = 'resolution' and new_value = 30

[msq]

thanks .. It is working ...

I am using following query for the same.

SELECT bug_id,
FROM bugs.mantis_bug_history_table
WHERE new_value = '30';

Can you please let me know how can i filter based on dates.

regards

[atrol]

there is a column date_modified which you can use for it

[suchariya]

This should be feature in mantis it self to check report like how many issues are reopened.

Consider that the project is about to close and almost all the issues are close now. but now someone wanted to check that in this project, how many issues get reopened ? which shows the health of developer on this project.