Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Poorva_Mehta March 27, 2020

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!

1 answer

0 votes
Mohamed Benziane
Community Champion
March 27, 2020

Hello,

Can you try this :

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

Hope this helps

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events