Issues which are reopened - how to select?

Hi All,

we just met a difficult request from a project leader: they have 20 more projects with cca 3000 issues. They need to report all those issues which were ever reopened (no matter how many times). The problem here that we don't use Reopened status: each issue which were reopened will be Open again.

I made a custom field for this and a post function to each reopening transition (Resolved ->Open, Closed -> Open) which set the custom field's value. But it's not retrospective: this method is valid only from today.

Do you have any idea, script, anything which we could list the ever reopened issues with?

Thanks in advance!


2 answers

1 accepted

1 vote
Accepted answer
Penny Wyatt Atlassian Team Apr 21, 2013

If you want to search historical transitions, use the "CHANGED" operator. e.g.

status changed from "Resolved" to "Open"

You could use the advanced jql for your status field.

Like this : status was in (Open) and status was in ("In Progress") and status is Open

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,099 views 4 9
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