JQL for Filter by date and status

[Adam Kwietniak]

I was trying to create a special filter. I called it "Archieved" and after clicking it I'd like to hide issues ONLY in "Done" column and updatedDate older than 5 days. So basically, issues done some time ago, because I have like a 80 issues in "Done" column.
This is my filter: updatedDate >= -5d AND status != Done

Can you help me? I think this "AND" doesn't work.

[Bloompeak Support · Accepted solution]

Hi @Adam Kwietniak ,

Let's start by finding the JQL that returns the ones you want to hide. It is

updatedDate<-5d AND status=DONE

Now, negate the above JQL and we are done.

updatedDate >= -5d OR status != DONE

 Hope it works.

[Adam Kwietniak]

Thank you very much!

[Lydia M]

I need to do something similar, but I need to see all the issues in a project that were completed in the last 5 weeks. So
Project = ABC and status = Done AND updatedDate  --is within the past 5 weeks--

I've tried updatedDate < 5w but I'm not able to narrow it down by the time frame I need. Any suggestions?

[Bloompeak Support]

@Lydia M,

updatedDate <-5w returns all updates including status changes. But you are specifically looking for status transition update. So below can work.
Project = ABC and status = Done AND status changed TO "Done"  during (-5w, now())

[Lydia M]

That worked perfectly, thank you!