JQL to list out the time spent and the original estimate for a ticket.

[prabu m]

We have created a task (common task like learning process) in the Jira, and multiple users are added a time spent in that task. For example,

User 'a' added 3h for 21/05/2020 and

User 'b' added 2h for 22/05/2020 again 

User 'a' added 5h for 22/05/2020

I want to generate a report (write a JQL query) to calculate the user 'a' ,how much time spent in that task  same for user 'b' also.

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi

Have you tried Team Worklog Reports ?

Regards

[prabu m]

@Jack Nolddor _Sweet Bananas_ No, is it possible from JQL? because I need to show this in our Jira Dashboard?

User wise time spent for the particular Jira id. 

[Jack Nolddor _Sweet Bananas_]

JQL has not groupBy operator, so you cannot  sum() worklogs.

To report worklog on Gadgets you can use Time Reports (PAID) third-party app.

Regards

[prabu m]

@Jack Nolddor _Sweet Bananas_Thanks, Let me check the app.

[Ligia Merciu]

Hi there,

You can use 

worklogAuthor in (user a, user b) ORDER BY key ASC/DESC

and select the Σ Time spent column to display.

[Jack Nolddor _Sweet Bananas_]

I believe the field Σ Time spent does not split the results by users which is the OP requirement.