Exclude multiple statuses in querry

jeroen.kuijper
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 4, 2019

Is it possible to use Jquery to search for issues without a status closed or done.

If i try this with the following statement my other filter option gets ignored like issuetype.

project = x and issuetype = story and status != closed or status != done

 

Anyone found a solution to this?

3 answers

1 accepted

8 votes
Answer accepted
Parvez Misarwala November 4, 2019

Below is the query

project = x and issuetype = story and status not in (closed, done).

You can also write

project = x and issuetype = story and resolution is empty

jeroen.kuijper
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 5, 2019

Thank you for the swift reply

Christos Moysiadis
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 5, 2019

Ahhh the page was not refreshed when i posted my answer! :P 

0 votes
justen_dawson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 6, 2023

the logical expression needs to update such that:
project = x and issuetype = story and status != closed and status != done

0 votes
Christos Moysiadis
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 5, 2019

Hello @jeroen.kuijper ,

Try it like this

  • project = x and issuetype = story and status not in (Closed,Done)
Alex Shchekin
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 22, 2022

this doesn't work for me (

Mithila N Bhat May 6, 2022

@Christos Moysiadis this dosent work for me (on the cloud version). Any idea what im doing wrong?

james_mallorie
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 5, 2024

If this doesnt work. I have found that if the status is multipart, as in (two words) then use quotation for the two word entries. for example ... try this.. 

 

project x and issuetype = story and status in ("to do", closed)

 

This worked for me. ^ 

Suggest an answer

Log in or Sign up to answer