JQL to fetch hours logged by list of defined people

[Sandeep Vashisht]

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?

[Ste Wright]

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".

Ste