MY SQL query to extract time spent on ticket

Question

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?

Mariana_Pryshliak_Saasjet_qysy8m · Accepted Answer

Hello @neeta_dubey

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