Exclude Done Issues Older than 5 months from JQL statement

Karin Biedermann April 19, 2024

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

1 answer

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 19, 2024

Hi Karin,

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

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 19, 2024

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:

Kind regards,
Bill

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 19, 2024

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

Suggest an answer

Log in or Sign up to answer