How do I do a status NOT statement?

[David Englund]

My basic query below includes an order by status, but I also want to exclude all items where status is "Done." Can someone please help? Thanks!

assignee in (ID number) ORDER BY status ASC

[Nic Brough -Adaptavist-]

Welcome to the Community!

Add "and status != done" into the query.  Or "and status not in (done, closed, ended)" type stuff to exclude several status.

[Trudy Claspill]

or "and statusCategory!=Done" to exclude any issue that has a Status that has been defined as a member of the "Done" Status Category. Then you don't have to list all the done Statuses if you use more than one.