MY SQL query to extract time spent on ticket

Hi All,

We have JIRA 8.5.1 and would like to know if there is a my sql query to extract time spent by each user on a particular ticket?

1 answer

Community moderators have prevented the ability to post new answers.

1 vote

Answer accepted

Here is a short guide what you should do:

- Go to your issue navigator > Select List view > Add the columns you want for your view (Time tracking fields, assignee, Sprints, etc)

- Then, add the following query to in the filter bar (Advanced mode):

ORDER BY assignee ASC, sprint ASC

Your issues will be ordered by its assignee and by their Sprints.

Hope it helps

Best regards, Mariana

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.