Exclude Done Issues Older than 5 months from JQL statement

Question

Dear all,

I am currently filtering for all Issues that are related to my team. I want to exclude all issues that have been set to done in the last 5 months (automatically updating with each day - thus bound to current login).

Could you help me out here?

KR Karin

John Funk · Answer

Sorry - yes, thank you for the correction @Bill Sheboy !!

Bill Sheboy · Answer

Hi @Karin Biedermann and @John Funk

John, did you mean to use AFTER startOfDay(-5M) rather than > startOfDay(-5m) in that query to use months?

Karin, here is some free training and documentation from Atlassian to learn how to make such queries in the future:

* https://university.atlassian.com/student/activity/1225443-intro-to-jql-in-jira-software-course-description
* https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql
* https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-operators-reference-939938745.html

Kind regards,
Bill

John Funk · Answer

Hi Karin,

Add this to your filter: AND status changed to Done > startOfDay(-5m)