Forums

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

JQL filter to show all issues in a project but Done/Closed tickets resolved only in the last 7 days?

Morgan_Thompson February 12, 2020

Pretty much what the title says. I need a filter that will display every issue in a project with the exception that Done/Closed tickets must have been resolved only in the last 7 days. I'm not super great with JQL and have been banging my head against this for awhile.

2 answers

1 accepted

1 vote
Answer accepted
Thomas Magny-Garcia
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.
February 12, 2020

Hi @Morgan_Thompson 
If I understand you should try

project = YOURPROJECT AND resolutiondate > -7d OR resolutiondate is EMPTY

That will give you all recently resolved tickets and the tickets unresolved.
In fact, want you exclude all tickets resolved a long time ago ?

 

Hope it helps !

Aylin Kohls
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.
February 13, 2020

Hi! only one small thing, use of the parenthesis:

project = YOURPROJECT AND (resolutiondate > -7d OR resolutiondate is EMPTY)
Morgan_Thompson February 13, 2020

This works perfectly. Thank you!

0 votes
Jack Nolddor _Sweet Bananas_
Atlassian Partner
February 12, 2020

Hello Morgan,

 

Try this JQL, using Advanced searching:

project = YOURPROJECT AND resolutiondate > -7d

 

References:

 

Regards

Morgan_Thompson February 12, 2020

Hi, thanks for your answer. Unfortunately, that JQL only shows issues resolved in the last 7 days. Which is needed, but I also want to show all unresolved issues.

Suggest an answer

Log in or Sign up to answer