Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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!

2 answers

1 accepted

1 vote
Answer accepted

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

Thanks so much Ioana!

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

Thank you, Bastian!

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you