nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Paul O_qqk8km

Couple of options:

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

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

All comments

Paul O_qqk8km

Couple of options:

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

(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_qqk8km

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server