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

Accepted answers

Mehmet A _Bloompeak_

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.

All comments

Mehmet A _Bloompeak_

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?

Mehmet A _Bloompeak_

@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())

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

atl-gruland