Forums

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

Filter for the issues resolved last week

Vijayasree
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 26, 2018

Need a filter for the issues resolved last week (not the current week)O from last sunday to last saturday

2 answers

5 votes
Udo Brand
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.
March 26, 2018

If an issue is resolved a resolution is set, so you can use:

Resolution changed during (startofweek(-7d), endofweek(-7d))
2 votes
Shakiru Ayanloye
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 26, 2018

Hi Vijayasree,

 

You can use something like

"project = SSA AND created > startOfWeek(-7)  and created <= startOfWeek(-1)".

 

Start of the week in Jira is Sunday. So in the case of the example above, it'll be from Sunday to last Saturday. 

 

I hope this helps

 

Regards,

Wikus Oosthuizen
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 10, 2023

Not sure if the function changed since this was last updated, but currently startOfWeek(-7) would go back 7 weeks, so if you want the start of the week before, you need to do startOfWeek(-1)

 

So to update the example:

project = SSA AND created >= startOfWeek(-1)  and created < startOfWeek()

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events