how do i exclude a status on one issue type only in a filter query

[Joakim Wöntner]

i want to be able to filter out closed and verified status on only bugs. this is my current filter.

project = XXXX AND issuetype in (Bug, Epic, Task, "Bug (Sub-Task)", Sub-task) AND "TYP: Team[Dropdown]" = "XXXXXX" ORDER BY Priority DESC

Ranking

Any advice how to do this ?

[Nic Brough -Adaptavist- · Accepted solution]

You probably want to add a clause for 

and not (issuetype = Bug and status = verified)

The brackets here are critical, if you miss them when adding that to your query, it won't do what you expect.

I think I'd probably start with:

project = XXXX AND issuetype in (Bug, Epic, Task, "Bug (Sub-Task)", Sub-task) AND "TYP: Team[Dropdown]" = "XXXXXX" and not (issuetype = Bug and status = verified) ORDER BY Priority DESC

Ranking

[Sebastian Krzewiński · Accepted solution]

Hi @Joakim Wöntner 

You need to use OR in your query. It should looks something like this:

project = XXXX AND ((issuetype in (Bug) and stastus not in (Closed, Verified)) or issuetype in (Epic, Task, "Bug (Sub-Task)", Sub-task)) AND "TYP: Team[Dropdown]" = "XXXXXX" ORDER BY Priority DESC

Remember to use brackets to "close" OR. Wihtout that you will get more issues than you expected.

More info: https://jirasupport.files.wordpress.com/2019/07/atlassian-jql-cheat-sheet-2.pdf

[tristan.cruickshanks]

FYI:  typo - stastus not in (Closed, Verified)) 

[Grigory Salnikov · Accepted solution]

Hi @Joakim Wöntner 

Try something like this:

project = XXXX AND ((issuetype in (Epic, Task, "Bug (Sub-Task)", Sub-task) OR (issuetype = Bug AND status not in (Closed, Verified)) ) AND "TYP: Team[Dropdown]" = "XXXXXX" ORDER BY Priority DESC

If I got the idea right 

[tristan.cruickshanks]

FYI:  typo - stastus not in (Closed, Verified))  - (sorry meant for above reply)

[Joakim Wöntner]

Thanks guys got the bracket thing now :) thats how you do the link.

[Grigory Salnikov]

You are always welcome!