Tempo/Jira Task <- Project/Epic/Story timesheet roll ups

Michael_Pinkerton

Hi All

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.

 

Our setup...

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.

Kristian Walker _Adaptavist_

Hi Michael,

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.

Regards,

Kristian