Need Help with JQL Query

Question

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?

Evgenii · Accepted Answer

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

Trudy P Claspill · Accepted Answer

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)