nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Morgan_Thompson

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.

Accepted answers

Thomas Magny-Garcia

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 !

All comments

Jack Nolddor [Sweet Bananas]

Hello Morgan,

Try this JQL, using Advanced searching:

project = YOURPROJECT AND resolutiondate > -7d

References:

Advanced searching

Regards

Morgan_Thompson

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.

Thomas Magny-Garcia

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

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

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

Morgan_Thompson

This works perfectly. Thank you!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql

filter