Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JQL to show any issues set to Done in last 7 days

Dennis_H
Contributor
June 21, 2024

I'm trying to create a filter that shows any issues in a certain project that were set to Done in the last 7 days, but when I run what I have it shows everything in done status

Here is what I have:

 

project = "Project1" and status = Done and status changed to Done before -7d

It lists 7 issues and all of them were closed last year or earlier. If I run:

project = "Project1" and status = Done

I get the same results as the first query. What am I missing?

 

2 answers

3 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 21, 2024

Hello @Dennis_H 

@Daryl Marsh 's answer is wrong and will show a syntax error.

The correct usage to find issues changes to Done in the last 7 days would be

 

project = "Project1" and status = Done and status changed to Done after -7d

 

The "-7d" criteria says "the date 7 days before now", so as of today that would be June 14. With the before keyword you were asking for the issues changed to Done before June 14. If you want the issues changed just in the last seven days then you need those changed after June 14.

0 votes
Daryl Marsh June 21, 2024

Should use > instead of before. Here is a link that might help - https://community.atlassian.com/t5/App-Central/How-to-filter-issues-by-dates/ba-p/1706097

 

Suggest an answer

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

Atlassian Community Events