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!

Rumi

2 answers

1 accepted

3 votes

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
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
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

132 views 0 3
Join discussion

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