Need Help with JQL Query

[Nichelle Wagner]

I am trying to create a query that excludes "Project Admin, Complete, and Cancelled projects.  However, I cannot seem to get the query to work properly as it still returns Complete and Cancelled projects.

project = "SBS - Storage Solutions Category" AND issuetype = Epic AND status not in ("Project Admin", Complete, Cancelled) AND Key >= SBS-101 AND assignee = xxxx OR assignee = xxxy OR assignee = xxxz ORDER BY assignee ASC

What am I missing?

[Trudy Claspill · Accepted solution]

Hello @Nichelle Wagner 

Welcome to the Atlassian community!

I suspect this has to do with the OR conditions in your JQL.

Are you trying to retrieve issues that match all these conditions...

project = "SBS - Storage Solutions Category" AND issuetype = Epic AND status not in ("Project Admin", Complete, Cancelled) AND Key >= SBS-101

...and that also match the condition of being assigned to one of the three specified users? If so, then change you JQL thus:

project = "SBS - Storage Solutions Category" AND issuetype = Epic AND status not in ("Project Admin", Complete, Cancelled) AND Key >= SBS-101 AND assignee in (xxxx, xxxy, xxxz)

[Nichelle Wagner]

Cool!  That worked as well.  Thank you.  Just starting to use JQL. I appreciate all the responses..

[Evgenii · Accepted solution]

Hi, @Nichelle Wagner 

Try

project = "SBS - Storage Solutions Category" AND issuetype = Epic AND status not in ("Project Admin", Complete, Cancelled) AND Key >= SBS-101 AND (assignee = xxxx OR assignee = xxxy OR assignee = xxxz) ORDER BY assignee ASC

[Nichelle Wagner]

Yah, it worked! Thank you.