Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL to fetch hours logged by list of defined people

Can we fetch the sum of hours logged in a ticket by a specific list of people.

For eg: If in a ticket lets say people A,B,C and D logged hours than i need a to pull the sum of hours logged by People A and B only.

Any JQL?


1 answer

0 votes

Hi @Sandeep Vashisht

You can't fetch the sum of hours logged via JQL.

Even though you can customise the JQL to show issues where work was logged by specific users using WorklogAuthor in JQL - the time spent would still show the total value of time spent, as WorklogAuthor is just showing issues a user logged time on, rather than their specific time values.

If you want more enhanced reporting, I would consider a worklog report add-on - you could try looking for worklog in Atlassian Marketplace - click here to see that, or other keywords such as "Timesheets".


Suggest an answer

Log in or Sign up to answer

Community Events

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

Events near you