Issues which are reopened - how to select?

[Rumceisz]

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!

Rumi

[Penny Wyatt (On Leave to July 2021) · Accepted solution]

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

status changed from "Resolved" to "Open"

[Peter Van de Voorde]

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

[Peter Van de Voorde]

Some more info : https://confluence.atlassian.com/display/JIRA/Advanced+Searching