Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL for "Closed since last Wednesday"

Scott Beeson
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.
July 10, 2023

We have a weekly meeting on Wednesday. I want to run a report on Tuesday for all tickets that have been closed since the previous meeting. A couple weeks ago, I wrote this:

project = "FISV" AND resolved >= startOfWeek(-4) ORDER BY Resolved

It seemed to work. However, this morning when I checked it, it's showing things closed on June 26th. This is two Wednesday's ago.

How can I create a saved filter that dynamically will show all tasks closed since the previous Wednesday?

For bonus points, why does this one show things closed before the previous week?

1 answer

1 accepted

3 votes
Answer accepted
Scott Beeson
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.
July 10, 2023

Looks like I may have simply been missing the "d". 

project = "FISV" AND resolved >= startOfWeek(-4d) ORDER BY Resolved

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events