Running a filter on multiple statuses

[Colum McAndrew]

I'm trying to run a search filter to list:

• All tickets on a specific project
• That do not have one of two statuses
• Contain a specific label.

Here's the filter being used:

project = "<PROJECTNAME>" AND labels = <LABEL> AND status != ("STATUS1", "STATUS2") order by created DESC

This returns an error despite all the indications that adding the statuses inside brackets should work.

If I run a search on each status individually, it works as expected. Can you help me with the syntax required to get the results in a single list. Many thanks.

[Kevin Johnson · Accepted solution]

Hi @Colum McAndrew ,

• project = "<PROJECTNAME>" AND labels = <LABEL> AND status in ("STATUS1", "STATUS2") 
• project = "<PROJECTNAME>" AND labels = <LABEL> AND (status = "STATUS1" or status = "STATUS2")

Any of these should probably work.

Cheers, Kevin.

[Colum McAndrew]

Thanks @Kevin Johnson The later example worked. 

BTW I meant to say that I wanted to exclude two statuses, not include. My bad, and I amended the original post. For the benefit of anyone following this, it was just a simple case of using status != rather than status =.

[Kevin Johnson]

= instead of != should work and you can also use "not in".

Cheers, Kevin.