JQL-How do I filter out all tickets based on a particular status updated during a certain time frame

Poorva_Mehta

Hi,

I want to filter out all the Bug tickets which have been updated as Resolved, Resolved on Live, Moved to Live during a certain time frame say yesterday irrespective of their current status say Closed/Reopened.

 

I tried JQL query,

issuetype = Bug AND status in ("Moved to Live", Resolved, "Resolved on LIVE") AND cf[10200] = Live AND statusCategoryChangedDate >= 2020-03-26 AND statusCategoryChangedDate <= 2020-03-27 ORDER BY statusCategoryChangedDate DESC, key ASC, created DESC

Also,

project = "GLAdmin" and status changed during (2020-03-26, 2020-03-27) FROM ("resolved") TO ("moved to live") but it did not worked.

Please help!

Mohamed Benziane

Hello,

Can you try this :

Project =ABC and status changed from "status a" to "status b" during (start date, end date)

Hope this helps