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
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.
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.
It looks like you're new here. Sign in or register to get started.
