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

[Natalia_Kovalchuk_SaaSJet_]

Hi @Gaurav Tiwari,

As I know, JQL doesn't allow searching based on historical status changes. Therefore, it is not possible to get a list of all issues that were reopened at any point during their lifecycle. Using the query ' status = Reopen' only shows issues that are currently in this status. 

I can recommend Issue History for Jira app from my team for this task. It tracks all changes to issues, including status transitions like “Reopen”. It allows you to see who made the change, when, and on which issue.

Using Issue History for Jira app, you can:

• See all issues that were ever moved to the "Reopen" status.

• Filter by user if needed.

• Export data in Excel or CSV formats.

To get the list of issues that were reopened by anyone from your team, irrespective of their current status, you need to do the following:

1. Open the app.

2. Use the filters needed (by project, data range, etc.).

3. In the Status column, choose the transitions to "Reopen". For example:

4. You will get a list of issues that were ever moved to "Reopen" status.

The app is available on the Atlassian Marketplace, so that you can try it for your specific use case: Issue History for Jira.

Hope it helps you. 

[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? 

[Petru Simion _Simitech Ltd__]

Hi @Gaurav Tiwari 

If you are open to using apps you can use Issue History Dashboard for Jira (Work Item History) an app delivered by our company.

You can filter your search by: Updted By - yourself, Field Updated - Status, Value To - The value of your first step in the workflow. 

The result is exportable to CSV.

Regards, 

Petru

[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.