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

Josh Allen_93onke

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 P Claspill

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