JQL - show all issues (But not assigned Jack, Jill) and also unassigned

[Josh Allen]

Hey,

I'm trying to see all issues in Project SF which are assigned to anyone in that project EXCEPT Jack and Jill. I don't want to see Jack and Jill issues, just everyone else's issues AND those that are unassigned. I also need specific status' as shown below.

I'm so close, but I can't get it to show only one project. 

project = SF AND status in ("In Progress", "In Review", "To Do", "Ready for Development") AND assignee not in (Jack, Jill) or assignee is empty ORDER BY created DESC

Everything works great when excluding Jack and Jill, but I wasn't seeing the unassigned issues. When I added "or assignee is empty" it does show the unassigned issues, but it shows them for all Jira projects, not just project SF.

[Trudy Claspill · Accepted solution]

Hello @Josh Allen 

Try enclosing the assignee criteria in parentheses, before the first "assignee" and after "empty":

project = SF AND status in ("In Progress", "In Review", "To Do", "Ready for Development") AND (assignee not in (Jack, Jill) or assignee is empty) ORDER BY created DESC

[Josh Allen]

Ahhh, yes!

Thank you so much. My dev team will be so happy.

I knew y'all would have the right trick.

[Laurie Sciutti]

Hi @Josh Allen ~ try putting parentheses around assignee not in (Jack, Jill) or assignee is empty

[Josh Allen]

Thank you!