How to show all open tasks/stories/etc but not "done"

[Leon Sandow]

I have a query:

assignee = xxxx OR assignee = xxxx OR assignee = xxxx AND status not in (Done, Resolved) ORDER BY assignee, key

But it still shows Status: Done tickets. I've tried a ton of variations, like status in EMPTY and status not in (done, resolved) and also resolution not in Done, but everything I've tried so far still shows tickets that are Done. It's got to be something really silly, right? 

[Paul O · Accepted solution]

Couple of options:

assignee in (xxxx, yyyy, zzzz)  AND status not in (Done, Resolved) ORDER BY assignee, key

or

(assignee = xxxx OR assignee = yyyy OR assignee = zzzz) AND status not in (Done, Resolved) ORDER BY assignee, key

[Leon Sandow]

I had my doubts because I'm still not 100% sure why mine didn't work (I guess it must be because of the OR statements on the assignees? So I was getting no "dones" from one assignee, but "done" stuff from the other two, maybe?), but this is perfect and I learned a more efficient way to list users. Thanks a mil!

[Paul O]

Yes, it’s the ORs and ANDs - exactly as you say. Just wrapping the clauses in parentheses clarifies the statement. Always beware multiple ANDs and ORs in jql