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

Question

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?

Trudy P Claspill · Answer

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.

Daryl Marsh · Answer

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