MY SQL query to extract time spent on ticket

[neeta_dubey]

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 · Accepted solution]

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