list of reopen issues irrespective of their current state

[Gaurav Tiwari]

i want list of all the tickets that were reopen (by me or anyone) irrespective of their current status/state in their life cycle

[Trudy Claspill]

Hello @Gaurav Tiwari 

Welcome to the Atlassian community.

Is this a one-time need or an ongoing need that will serve many people or solve a business problem?

As mentioned by @Usman there is the WAS operator which can be used to find issues that was in specified statuses.

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#WAS

There is also the CHANGED operator to select issues that were changed to, changed from, or changed to/from specific statuses.

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED

The ideal solution would be if this operator could be used with the statusCategory, but that is not currently supported.

If you don't have a status that specifically means "Reopened", or allow issues to be changed from "done" statuses to other "not-done" statuses, then you could use the CHANGED operator but would have to list out all those statuses in the JQL.

A go forward solution could be to have a separate field to indicate "reopened" and set that with Automation Rules that are trigged by "Work Item Transitioned" and detect if the previous status was in the "Done" category and the new status is not in the "Done" category. That doesn't help with the issues that already exist though, and could negatively impact your Automation Usage Limit.

Another option would be to find a third party app that extends JQL functionality with a function that would support your query. Are you open to acquisition of such an app? 

[Ayça Erdem_OBSS_]

Hello @Gaurav Tiwari 

Welcome to the community 

If you're looking to get a list of all tickets that were reopened at least once, regardless of their current status or position in the workflow, I'd recommend checking out Timepiece - Time in Status for Jira, developed by our team at OBSS.

With the Status Count Report feature, you can:

• See how many times each ticket  comes to spesific statuses like  "Reopened"

• Filter issues that have at least one time those issues come to specifis statuses

• Analyze patterns of rework or instability in your lifecycle

Here is the sample screenshot from Timepiece app;

Tiimepiece reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts. And the app has a REST API so you can get the reports from Jira UI or via REST. Also you can export the reports in to various formats easily. 

Let me know if you'd like help setting this up.

Best regards

Ayça

[Usman]

Hello @Gaurav Tiwari 

To list all tickets in Jira Cloud that were ever reopened (regardless of their current state or who performed the reopen), you can use Jira Query Language (JQL) to leverage issue history.

status was Reopened

This will return all issues that have ever been in the "Reopened" status, irrespective of their current state or who made the status change

Considerations

• If your workflow uses a different status name for reopened issues (e.g., "Re-opened", "Reopen"), replace "Reopened" in the JQL accordingly.
• This query works for any user; it’s not restricted to issues reopened only by you.
• No matter the current status of the issue (open, closed, in progress, etc.), if it was ever in the "Reopened" status, it will show up in the results

Filtering the Results

By project:
project = XYZ and status was Reopened

For specific timeframes:
status was Reopened DURING ("2025-01-01", "2025-06-30")

[Trudy Claspill]

Note that this works only if you have a status that specific means "reopened". This doesn't work if reopening to you means changing the status from any status in the "Done" Status Category to any status in the "To Do" or "In Progress" status categories.