How to write this JQL query

[Yolonda Habimana]

Available statuses in our JIRA system are To Do, In Progress, For Testing, In Testing and Done, and we don't have a status called Reopened, How can I write a JQL query that will retrieve all issues of type "bug" that has been re-opened by one of our quality team members in the past two months *

[AKBAR · Accepted solution]

Hey Habimana,

However your quality team members might have closed the bugs using "Done" status as you don't have a re-opened status.

So tell them we cannot decide which ticket has been re-opened, I can only give the Closed tickets and based on Summary or Description you must decide which bugs have re-opened.

I hope you know the JQL for Done status for the past 2 months.

Apologies if I'm wrong..!!

Thanks,

Akbar.

[Yolonda Habimana]

Thank you for the feedback Akbar!  There are definitely some changes we need to make in how we do things around here.  

[Ollie Guan]

Hello @Yolonda Habimana ,

Please modify the following statements according to your expectations.

status changed FROM "done" to "in progress" and status changed by Ollie and status changed DURING ("2019-01-01","2020-03-15")

[Yolonda Habimana]

Thank you so much Ollie, this helps a lot!!!