Need to exclude Not required tickets from a filter

[Shari Fitz-Patrick]

I am trying to remove Not Required tickets from a filter but not having any success.  This is what I have done 

project in (RET) OR (project = Merchant AND labels = RET AND status NOT IN ("Not Required")) ORDER BY Rank ASC

[Amanda Barber · Accepted solution]

Hey, @Shari Fitz-Patrick - is this for a Jira Product Discovery project or regular Jira? Do you perhaps have more info on what's being returned that shouldn't be? From a quick glance, I'm wondering if this would solve it for you:

project in (RET) OR (project = Merchant AND labels = RET) AND status NOT IN ("Not Required") ORDER BY Rank ASC

If this works, it's because you had the status included in the parenthesis so anything in project RET would have been returned regardless of status.