show all tickets set to done within last 7d

[Michael Blaut]

Hi,

I'm trying to build a Jira filter that shows all tickets that have changed their status from to do to done within the last 7 days. While the first part is easy I just can't seem to figure out how to get the 7 day rule.

This is what I have:

project="name" AND status changed from "to do" to "done" 

I believe this is rather easy but I'm just blocked....

[Tarun Sapra · Accepted solution]

This should work

project = "Name" and status changed FROM "to do" TO "Done" AFTER -7d

Here "-7d" means last 7 days. 

[Michael Blaut]

thx that worked!

[Alexey Matveev]

Hello, 

It would be something like this

status CHANGED FROM "In Progress" TO "Open" AFTER -7d

or to be more exact

status CHANGED FROM "In Progress" TO "Open" AFTER startOfDay(-7d)

startOfDay will let choose from 00:00 while -7d will depend on the time when you execute the query