Making reports "Overall Time Spent" including archived hours?

Added by Slava Karg about 9 years ago

Hello!
We manage many short-time projects in redmine and when one is finished we would like to Archive it in order to simplify "Projects" view. However our managers often use report "Overall Time Spent" (at "Projects" page) to control employee's spent time. And we noticed that this kind of report does not count spent hours of projects that were Archived.
So we would like to have a possibility archived hours to be added to these reports, something like adding administrative checkbox option 'Count archived projects'.

I tried to analyze MySQL requests while making these reports and found out that there are two statuses of projects: Active and Archive (with "1" and "9" values corresponding). And these requests contain "filter" like "WHERE (projects.status=1 ...". So if we for example remove this filter from that requests we would get what we want. But I dont know how to do that.

Does this problem have a solution?
Best Wishes!

Replies (4)

RE: Making reports "Overall Time Spent" including archived hours? - Added by Nick Nguyen about 8 years ago

This is also something I would like to see. I would like to review time spent on projects month over month. But if I archive a project since it is now complete, that project disappears from the overall time activity log.

Any assistance in where i can set this?

RE: Making reports "Overall Time Spent" including archived hours? - Added by Ralf S. about 7 years ago

We would appreciate that feature (as descibed by Slava) too!

We use Redmine to follow several projects and their effort for months - but the overall effort-statistic becomes unusable, if we archive a project (due to the problem described above).

But we have to archive projects, because the list of projects gets too long for a weekly review.

I assume, several members could use this feature too..

RE: Making reports "Overall Time Spent" including archived hours? - Added by Rodrigo Merola Winterhalter about 7 years ago

This feature would be great...My boss ask me how to do that everyday!

(1-4/4)