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

What are the appropriate filter terms for Status is not "Backlog"?

Daj Oberg

I am trying to filter a number of Jira projects to get a set of all the Jira epic tickets that are scheduled to be worked on in 2021 or are being currently worked on. The query I have is: "project in ("AB", "CD", "EF") AND type = epic AND createdDate >= "2021/01/01" AND status is not EMPTY" but that gives me too many epics that aren't started. I have modified the results to ORDER BY Desc and that's a little help.

Thanks!

Accepted answers

Ioana_e7y08v

Hi Daj,

All issues have a status, so status is not EMPTY will not be helpful.

You can add something like status in (Status1, Status2) and list all the statuses that you are interested in.

You can also use statusCategory != Done to see only issues that are not in a closed state (do not Done, Closed, Resolved, Completed, etc). Or you could use resolution != Unresolved.

Regards,

Ioana

All comments

Bastian Stehmann

Hi @Daj Oberg ,

Welcome to the community.

You can just try ... and status =! Backlog if the backlog status is the only one you don't work on.

Or try status not in (status1, status2) to exclude status1 and status 2

Ioana_e7y08v

Hi Daj,

All issues have a status, so status is not EMPTY will not be helpful.

You can add something like status in (Status1, Status2) and list all the statuses that you are interested in.

You can also use statusCategory != Done to see only issues that are not in a closed state (do not Done, Closed, Resolved, Completed, etc). Or you could use resolution != Unresolved.

Regards,

Ioana

Daj Oberg

Thanks so much Ioana!

Daj Oberg

Thank you, Bastian!

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