Hello experts, can someone PLEASE help me with a way to extract the following information into an excel :
For e.g.,
Story XYZ
Task 1 - User A - 4h (logged)
Task 2 - User B - 2h (logged)
I need User A and User B logged hours each day in a spreadsheet. I have downloaded a trial version of JIRA on my PC. Here are some additional details:
Base URL | http://localhost:8080 |
System Date | Friday, 04 Oct 2019 |
System Time | 18:49:47 -0500 |
Current Working Directory | C:\Users\abc\Atlassian\JIRA |
Java Version | 1.8.0_202 |
Hello Balu,
Natively Jira stores the worklog on the issue and does not put together a list of the information per user, so the sum of the worklog not a directly queryable data point meaning it must be retrieved across all the issues and calculated manually from the avaliable data set.
There is a really good exe on how to do this on a per user basis from the API with example scripts linked via github repos in the following community post, which looks like it would fit your needs here, and would be a really good starting point:
Also, there are a lot of Time Tracking apps that can be added to the Jira instance that do extend this functionality, and provide various reporting options on user time tracking entries, and a list to review can be seen in the marketplace HERE, I recomend checking these out as an alternative method.
Regards,
Earl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.