I've found a couple of posts in here which offered suggestions but have not be able to get the solutions offered to work for my situation, so i'm now here asking after struggling with this problem all day.
We are using Tempo for timesheeting by individuals.
Our finance department run a report on Jira Project "Timesheet Tracking" where business/IT projects are assigned as tasks within the board and tracked as To Do, In Progress, Done.
Employees log time against these individual tasks or via linked child tasks in other Jira Projects. EG: TT-1 might have a child task called EG-1 in project EG and UserA has logged time against EG-1.
Additionally we have in some projects, tasks/stories under epics, with the epic linked to the TT code. EG: TT-1 has a child of EG-1 which is an epic with child EG-2 which is a story.
What I'm trying to get working, either using default Jira or Scriptrunner, is a report that shows total time worked on the TT tasks (NOT INDIVIDUAL) which rolls up the time logged against all children levels. This is so finance can have a real view of all the time logged against a TT code.
Does anyone have any suggestions on how to achieve this or a better way of doing this?
I have entered the company with the process already established and hoping that I can reduce some work for the finance team through targeted reporting.
Thank you for your question.
I can confirm that ScriptRunner for Jira Cloud is unable to provide a report inside of Tempo as we cannot change the way that Tempo works as Atlassian do not provide the API's to do this.
I can confirm that Atlassian provides the Get Worklogs API's which returns all worklogs for a specified issue as described here and to achieve your requirement in ScriptRunner for Jira Cloud you would need to get the worklog for every required issue and aggregate up the results.
I understand that this response is frustrating but unfortunately, there is no other API to get worklogs that ScriptRunner for Jira Cloud is able to use.
Finally, I can confirm that Tempo have their own rest API which you may be able to use to achieve your requirement and I would advise reviewing the Tempo API's located here in order to see if this API can provide the data you require.
If this response has answered your question can you please mark it as accepted so that other users can see it is correct when searching for similar answers.
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events