Jump to content

Time Reporting in Project Manager


Ann
 Share

Recommended Posts

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

Link to comment
Share on other sites

@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

 

image.png

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...