JQL to find total time spent on particular transition by role member

Question

How to find total time spent on particular transition by particular role or role member.

Mehmet A _Bloompeak_ · Answer

Hi @Gajanan Sasane ,

You are looking time spent on statuses by assignee. I am afraid it is not possible to get that info with JQL. As far as I know, there is no marketplace app that achieves it. There are apps to get time spent on each status or time spent on each assignee. But none of them provides status and assignee time breakdown at the same time. The only way is to code the below logic by yourself:

* Call Jira rest api and get issue history
* Parse the json response and make your calculations

Zoryana Bohutska _SaaSJet_ · Answer

Hi @Gajanan Sasane

Also, you can try Time in status for Jira Cloud (developed by my team). It automatically generates reports of time issues spend in each status and time each user was assigned to issues.

Regards

Michael Andolfatto_a62ntx · Answer

Hi @Gajanan Sasane ,

JQL is used to return sets of issues, if that data does not exist in a custom field then JQL will not be of help.

You can take a look at some Marketplace Plugins such as Time In Status which can breakdown how long an issue has lived in a particular state by user.