Hello,
I would like to get some statistics on projects from last year (for example real work sum by resource for the year for last year projects, which are now closed).
Looking at the reports, it seams it is not possible to get statistics or extraction of data from closed project.
Would it be possible to put a checkbox option like on other pages from projeqtor to allow selection of closed projetcs ?
Without that, I don't see how to exploit correctly the database to get data from projects without reopening them, which is not at all the way I would like to use the tool.
Thanks for your help !
Best Regards,
Louis C.
It seems it is subject of ticket #1101
Hello Pascal,
Effectively ticket #1101 seems to describe the same need as I have (taking also into account the cancelled projects).
So this is on the roadmap for future versions !
However, for the short-term, would you have any clue to be able to get some statistical information on closed project for imputations (I need to get the number of hours of each resource for year 2016 on each project, closed or not closed). Maybe some SQL request directly to the database ?
Thanks for your help !
Louis
select idResource, idProject,sum(work) from work where year='2016' group by idResource, idProject
Not tested but should work.
Attention, result is in days (not hours)
Thanks Pascal,
This code is working (putting work in lowercase) :
SELECT idResource, idProject,SUM(work) FROM work WHERE YEAR='2016' GROUP BY idResource, idProject
Not really easy to read but usable as a temporary solution !