How to find reopened bugs in Jira using advanced search feature for next gen projects?

Question

My project has below status

To Do

In Progress

Ready for QA

Testing/Validation

Done

Note: My project in jira is "Next gen"

When I reopen a bug, the status I assign is "To do"

I tried this query in advanced search

project = <project name> AND issuetype = Bug AND status changed to "To Do"

No results are returned

Mittal Saglani · Answer

Thank you for responding/

However my flow is:-

The defect/ item is moved to "testing/validation" status by the development team

I am the QA person, so I either pass it and move to "Done" or reopen it and move to "To Do" status.

Am looking to prepare dashboard reports and I need to find out the # of defects that were reopened in a current or past sprints. Basically need the history

I tried the query you sent and that doesn't give me correct results

Petter Gonçalves · Answer

Hello Mittal,

Welcome to Atlassian Community!

I understand that you are looking for a way to return all the issues that were reopened/moved from the Done status. Is it correct?

The query below should work to return all the reopened issues in your Next-gen project:

project = "projet name" and issuetype = Bug and resolution was EMPTY and status != done

That being said, the operators "Was" and "Changed" are indeed not working for Next-gen projects in JQL queries. We have a bug reported about this behavior here:

- JQL query search using "status was" returns incorrect unreliable results for next-gen projects

Feel free to vote and watch the bug to receive notifications about any updates.

Let me know if this information helps.