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

[Ankit Shah]

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.

[Ankit Shah]

Thanks for the quick response @Nic Brough -Adaptavist- . Are you aware of any specific app which will help me get this data? Or have you used any yourself till now?

[Nic Brough -Adaptavist-]

Scrptrunner and EasyBI are the two I've used for this sort of stuff most recently.

[Ankit Shah]

Thanks @Nic Brough -Adaptavist-