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

Accepted Answer
1 vote
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
Posted Tuesday in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

45 views 0 2
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