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
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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,293 views 14 20
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
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