How do you export time worked our of JIRA?

Randall Fisher
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 12, 2015

We have all this time logged in JIRA issues, but what is the best way to extract that for reporting back to accounting?  We have someone querying the tables, but when Atlassain changes the schema, those break.  There never seems to be the correct fields exposed in JQL to make this work.  Any suggestions? 

3 answers

1 accepted

1 vote
Answer accepted
Randall Fisher
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 6, 2015

Unfortunately, we have someone in management who is querying the data directly out of the tables.

1 vote
Michel Mathia July 24, 2018
James Foster October 27, 2018

Hi Michel,

I encourage you to give it a try if you haven't already.

I hope it's good for you. If it's not, email us your feedback and we'll make it good. :-)

Regards,

James Foster

0 votes
pkirkeby
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 12, 2015

Have you considered using reports from JIRA?

Or a plugin that provides additional functionality for this like https://marketplace.atlassian.com/plugins/jira-timesheet-plugin

 

Randall Fisher
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 13, 2015

We have the Timesheet plug-in, which helps greatly for the users to log there time, but getting that time back out of JIRA has always been a struggle. Most all of those reports are for reporting metrics that we really do not care about (ex. Estimated/Actual, How many hours did Bob Smith log vs. Cathy Jones, how much time was spent on release x.y.z). How can we create the reports we need? Reports that pull data on different aspects of different projects (Capex, Maintenance, etc.) with possible references to linked issues (uncovered by, blocked by)?

Suggest an answer

Log in or Sign up to answer