How to see a column in search that shows user's Work Logged per issue?

I need to show the auditors a list of issued that have logged hours by my developers.
What column can I use in Search should I use to be able to export to excel?

 

This is my JQL

project in (TURBO, TIMELOG) AND worklogAuthor in (Gantcheva, LapadatA, Fosticd) AND worklogDate >= 2015-01-01 AND worklogDate < 2016-01-01 AND issuetype in (Story, "Test Task")

 

Thanks.

1 answer

You need to add the Time Spent column/field. 

Hi Peter,

This is not returning what I need.

I need to report on the number of hours per user.

This is my query: project not in (TURBO, TIMELOG) AND worklogAuthor in (BoustanyJ) AND worklogDate >= 2015-01-01 AND worklogDate < 2016-01-01 AND issuetype in (Story, "Test Task", "Estimate Requests/Design", "Application Support", bug, Documentation, "DB Schema", "Hot Fix", "Service Request", Task)

For example in issue Acct-314, shows Time Spent as 6 hours and sum Time Spent as 3 days, 4 hours, but when I look at the Work Log tab in the issue, it shows that user Jade logged only 3 hours, not 6. There are 3 hours logged by another user.

 

Is there a better query I should use to filter only the time logged by specific users?

Thank you,

I'm not aware of other built-in ways to get this type of report. 

Unless you are using plugins like Tempo for improved time management or eazyBI for improved reporting this isn't that simple. 

However, if you are using Script Runner, which most are, you can use this JQL and most probably tweak it to your needs (join it with your current JQL):

issueFunction in workLogged('by user')

See more options here: https://scriptrunner.adaptavist.com/4.3.0/jira/jql-functions.html#_worklogged

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

590 views 2 15
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot