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; } } }

Trying to filter issues that are new, in progress and closed (in the past 7 days.)

Evan Sadowsky

I am trying to create a filter where I am displaying issues that are in the status of new, in progress, and closed. But I only want to display the closed issues that have been resolved in the past 7 days.

I am able to filter on closed items in the past 7 days, but cannot figure out how to display the new and in progress ones at the same time.

This is what I currently have:

issuetype = Issue AND status in (Closed, "In Progress", New) AND status changed to Closed after -7d

Accepted answers

Aswin Achuthan

@Evan Sadowsky try using OR command to join the results

example:

issuetype = Issue AND status in (Closed, "In Progress", New) AND ((status changed to Closed after -7d) OR (status changed to New after -7d) or (status changed to "In Progress" after -7d))

All comments

Aswin Achuthan

@Evan Sadowsky try using OR command to join the results

example:

issuetype = Issue AND status in (Closed, "In Progress", New) AND ((status changed to Closed after -7d) OR (status changed to New after -7d) or (status changed to "In Progress" after -7d))

Evan Sadowsky

@Aswin AchuthanIs it possible to show the new and in progress issues without the (changed in the past 7 days?)

So it would show all new issues, all in progress issues, and issues that have been closed in the past 7 days

Vasiliy Zverev

Hi, Evan!

So, you need to JQL filters for this:

first: created > -7d. This one will return all created within 7 days. It should be saved. Lets name it "created for 7 days'

second: resolution date > -7d and filter = "created for 7 days'. This filter will return issues created and resolved for 7 days.

Best regards, Vasiliy.

Evan Sadowsky

@Vasiliy Zverev This is part of the answer. Thanks! But I am trying to show three issue status's.

1. All New issues

2. All In Progress issues

3. Closed issues from the past 7 days.

Is this possible?

I want the be able to see all of the new and in progress issues, but have the closed issues disappear after 7 days.

Aswin Achuthan

try this

issuetype = Issue AND (status in ("In Progress", New) OR (status changed to Closed after -7d))

Evan Sadowsky

Thanks!

Vasiliy Zverev

Here you are: issuetype = Issue AND (status in ("In Progress", New) or (status = Closed and resolutiondate >= startOfDay(-7d)) )

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