How to get issue history details for Jira ticket between 2 statuses?

Ankit Shah_sriqbr

I have a Jira ticket which has gone back and forth between Status A and Status B. I want to get the count of how many times the ticket changed status between A and B. 

For example consider we have a ticket #1 with the following scenario- 

Resource A changed the status from "Internal Review" to "In Development"

Resource B changed the status from "In Development" to "Internal Review"

Resource A changed the status from "Internal Review" to "In Development"

Resource B changed the status from "In Development" to "Internal Review"

Resource A changed the status from "Internal Review" to "In Development"

Resource B changed the status from "In Development" to "Internal Review"

 

Now, if i need to get the count for this history, is there any way through JQL that it can be achieved? 

 

Thanks in advance

 

- Ankit

Nic Brough -Adaptavist-

JQL finds issues, it does not report on them.

You are going to need to find or write something that can extract that data from each issue and report on it.  There are several apps in the marketplace that provide "number of times in status" type reports and fields, and the ad-hoc reporting apps are good at it too.