How to - search for issues which are reopened?

Hi All,

we need a custom field which shows if the issue was ever reopened. The problem is that we don't use Reopened status: only Open (because of ITIL principles). Ever an issue was closed or resolved and need to be reopened then it will be in Open status again. So we cannot recognize the issues which are reopened because these also have Open status.

Thanks in advance for your advice!


2 answers

1 accepted

3 votes
Accepted answer

I'd re-introduce re-opened as a status and scribble "ITIL doesn't work for us in this case" on your ITIL docs.

If you aren't willing to do that, then a bodge that might work:

  1. Add a number field called something like "reopened count"
  2. Add a plugin that includes one of the "increment number field" post-functions
  3. Change the workflow - add the new post-function so that it adds one to the new field every time someone uses a "re open" transition

You can now filter for "reopened count > 0".

And what Chaithra says - that requires no plugins, and might be good enough (the solution I've posted was needed before you could run JQL with "status changed" type clauses, and we needed a reopened counter, so it's persisted)

I personally like a number field; I create one called "Times Reopened", and on transition from Closed to Open I increase the value by 1. :)

EDIT - Oh jeez, totally didn't see Nic's comment - changed my answer to a comment! :D

Hi Natalie,

that's also a good idea.

Sadly it cannot be usable retrospectively (past time):(

Mmm, yes that is true - but if you impliment it now, then you might find it useful in the future! ;)

Rumi is correct about the historical use of course. We did a bit of analysis and then posted data into some of the older issues, but it wasn't many.

You can use JQL query in filter to get the search result

Example: (status changed FROM Resolved To Open OR status changed FROM Closed To Open).

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,305 views 12 19
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