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 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 ?

Accepted answers

Grigory Salnikov_0hffsd

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

Sebastian Krzewiński

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

Nic Brough -Adaptavist-

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

All comments

Grigory Salnikov_0hffsd

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

Sebastian Krzewiński

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

Nic Brough -Adaptavist-

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

Joakim Wöntner

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

Grigory Salnikov_0hffsd

You are always welcome!

tristan.cruickshanks

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

tristan.cruickshanks

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

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud