Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Excluding tickets from a filter is not working as expected.

I created a filter for open issues, and need it to exclude tickets that have Done as status. I can't seem to be able to do that.

I copied the syntax (statusCategory != done) from a colleague's filter where they are excluded. I also tried using a different field (status != done) and still, I keep seeing Done tickets in the list.

What am I missing? Is the Status field in my project simply mapped to something different in JQL, and if so, how would I go about finding out what it is?

In case it helps, this is the full filter syntax (everything else I'm asking it to do, it's doing correctly):

 

component in ("Instant Awards & eCards", "Nominations & File Uploads", "Connect App") AND statusCategory != done AND labels = rnr-incident OR labels = rnr-request OR labels = rnr-improvement AND project = "Reward Gateway Development" ORDER BY priority DESC, status DESC

2 answers

1 accepted

1 vote
Answer accepted

Put some parentheses around the OR clauses

component in ("Instant Awards & eCards", "Nominations & File Uploads", "Connect App") AND statusCategory != done AND (labels = rnr-incident OR labels = rnr-request OR labels = rnr-improvement) AND project = "Reward Gateway Development" ORDER BY priority DESC, status DESC

This seems to have done the trick. Thank you so much!

Hi Federica,

you are using Jira Cloud? What statuses does your workflow have? Is the Done Status colored green?

Another option you might want to try is using: resolution is empty

Regards,
Kai

Thank you Kai!

Yes, the Done Status is indeed coloured green. 

Someone else suggested I format the query differently and that seems to have done the trick. I will keep "resolution is empty" in mind, too, in case it comes in useful in future.

Like Kai Becker likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
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