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

[Aswin Achuthan · Accepted solution]

@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

[Aswin Achuthan]

try this

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

[Evan Sadowsky]

Thanks!

[Senthilkumar]

hi @Aswin Achuthan i need your help in creating automatic watchers, when creating an ticket in jiRA.

Senthil

[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. 

[Vasiliy Zverev]

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