Issues which are reopened - how to select?

Rumceisz April 21, 2013

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

2 answers

1 accepted

1 vote
Answer accepted
Penny Wyatt (On Leave to July 2021)
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 21, 2013

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

status changed from "Resolved" to "Open"

0 votes
Peter Van de Voorde
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 21, 2013

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 21, 2013

Suggest an answer

Log in or Sign up to answer