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

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?


2 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?

Renjith Pillai Community Champion Jan 22, 2013

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

EIDT: You can do it yourself - https://confluence.atlassian.com/display/AOD/Disabling+or+Enabling+a+JIRA+Plugin

Suggest an answer

Log in or Join to answer
Community showcase
Jason Wong
Published yesterday in Agility Beta

Welcome to agility

Every team in the world is unique, and so   Atlassian believes   that each and every team's best way of working  needs to  be molded to their unique circumstances  – ...

279 views 6 15
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot