Time Reporting in Project Manager

[Ann]

Afternoon All

Hope you are all well and looking forward to the Easter Weekend.

We currently have some reports to show how much time has been logged against the reports, however it does not include the time spent on any changes that are linked to the project.  Please would it be possible for some help/advice?  Is there a way to report on all time logged against Changes linked to all projects please?  Thank you.

Kind Regards

Ann

[AlexTumber]

@Ann thanks for your post.

The way to do it currently would be through a couple of queries. The first would be to get a list of change request id's from the project relationships table and then run a second query to get all timesheet values for those specified requests, so something like this etc:

WHERE h_related_urn IN("urn:sys:entity:com.hornbill.servicemanager:Requests:CH00000182","urn:sys:entity:com.hornbill.servicemanager:Requests:CH00000183").

The more elegant, longer term solution however is for us to add a switch to these sort of time recorded views, that allows you to include time from project related service manager requests. I will speak with our development and product teams about this.

Alex

 

[Ann]

Thank you @AlexTumberthat is fantastic.  

Hope you have a lovely Easter weekend.