I need a filter that for all the defects that were resolved last week?

Evalaji Jones December 15, 2022

need to see what defects were resolved within the last week

2 answers

1 accepted

0 votes
Answer accepted
Tom Lister
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 15, 2022

Hi @Evalaji Jones 

by last week do you mean during the previous week or in the last 7 days?

try

project = MYPROJ and resolved >= startOfWeek(-1) AND resolved <= endOfWeek(-1)

or

project = MYPROJ and resolved > -7d
Evalaji Jones December 15, 2022

thanks. Does not work when I want to filter by issue type. any suggestions?

Sreenivasaraju P
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.
December 15, 2022

you can add 

issuetype = Bug or issuetype = Defects  or issuetype = "your specific issuetype" to above queries.

Evalaji Jones December 15, 2022

thanks for the help. It does work for single issue type but not for multiple issue types for e.g. 3 issuetypes in one filter. Still better than nothing!

Sid Pathirana
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.
December 15, 2022

Hi @Evalaji Jones - you can modify your filter query to get all your required issue types in the same filter by including a list of the issue types you are interested in, eg:

project = MYPROJ AND issuetype in (Bug, Story, Epic) AND resolved >= startOfWeek(-1) AND resolved <= endOfWeek(-1) ORDER BY resolved ASC, id

Evalaji Jones December 16, 2022

thanks @Sid Pathirana  will this work for -7 days? (last 7 days)

Tom Lister
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 16, 2022

You will need to use

project = MYPROJ AND issuetype in (Bug, Story, Epic) AND resolved >= -7d ORDER BY resolved ASC, id
Like Sid Pathirana likes this
Evalaji Jones December 16, 2022

thank you it worked!

 

I had to put 'OR' instead on 'AND' to include all 

Tom Lister
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 18, 2022

Great - could you mark as answered so the remembers will find it.

0 votes
Sreenivasaraju P
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.
December 15, 2022

Hi @Evalaji Jones ,

 

Welcome to the community, 

You can try below query. It will all the tickets resolved in last 7 days

resolved >= -7d

 

if you want to go by week like

 resolved >= startOfWeek()

Suggest an answer

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

Atlassian Community Events