How to build a query on finding the number of times a issue got re-opened?


I am able to build a query for finding issues that currently have or previously had, a status of Reopen.

Ex: status was in(Reopened).

I need help in build a query in finding the number of times a issue got re-opened?


3 answers

Hi sudharson,

JQL is only meant to return issues - it can't tell you how many times an issue was re-opened by default. You will have to go into the issue history for that.

However, you could add a field to the issue to track the number of times that an issue got reopened, and have that value increment each time the issue is reopened. This is possible with the JIRA Misc Workflow Extension:

which allows you to Increase the value of a field (which would work perfectly for this case).


Thanks Simon. Much Appreciated..!

I had a look at the URL for JIRA Misc Workflow Extension.

It looks, I need to Install the plugin by copying the JAR to WEB-INF/lib inside your JIRA web application and restart JIRA.

Kindly note, i am not a administrator. Hence, I am having the limitations of implementing it.

I am having user level privellages. To track my project very closely, I need to build a query to find the number of times the JIRA got reopened.

Do we have any other workaround.


Sudharson R

I'm afraid that you won't be able to write a query to find this unless you customize your JIRA instance in some way, either with the plugin or by some custom code. JIRA simply does not have the logic in place to track the history of workflow transitions and sum them.

Hey Simon,

We are having a similar issue where we want to have a first glance at how many times a cases was reopened without having to go through the history.

What you mentioned above could help us out greatly, but we are using the cloud based version of Jira. Is there anything similiar to JIRA Workflow Entension that we can use?

Workflow flow extentions are available on OnDemand. Please raise a support request to get it enabled for you.

EIDT: You can do it yourself -

0 vote
Tyler I'm New Here Mar 28, 2018

You can have a field that is not shown on the screen of the issue on create, edit, etc. but update it when it goes through a transition of "reopen" or something equivalent. Then you can query for that field having the specific value. 

This is only a half solution, as it can check if something has been reopened at least one time and is easy to implement.

As for a full solution, either using a plug in or writing a custom script that can increment a counter on a field is your only real solution.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

708 views 6 13
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you