Forums

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

Is there a way to filter for Jiras that have been iceboxed in the last 14 days?

Sarah Johnson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 25, 2022

I can filter all iceboxed Jiras but I specifically want to know which ones were iceboxed in the last 14 days.  I have this filter below but it doesn't work as the status category does not change from To Do when an issue is iceboxed even though the status itself changes to ICEBOX.

issuetype in standardIssueTypes() AND project in (xxx, yyy) AND status in (Icebox) AND statusCategoryChangedDate >= -14d ORDER BY summary ASC, priority DESC

1 answer

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Champion
October 25, 2022

Hello @Sarah Johnson 

Welcome to the community.

Yes! The solution is to use the CHANGED operator against the Status field.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CHANGEDCHANGED

With that operator you can enter a date range for when the change must have occurred.

Sarah Johnson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 25, 2022

Thank you Trudy, that worked!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events