show all tickets set to done within last 7d

Michael Blaut November 15, 2017

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....

2 answers

1 accepted

0 votes
Answer accepted
Tarun Sapra
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 15, 2017

This should work

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

 

Here "-7d" means last 7 days. 

Michael Blaut November 15, 2017

thx that worked!

0 votes
Alexey Matveev
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.
November 15, 2017

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

Suggest an answer

Log in or Sign up to answer