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; } } }

Statuses filtered out still showing

Trevor Kozar_4wsrxc

Hi there, I'm trying to create a filter that filters out certain statuses. I've tried every combination of "Status in" or "Status not in" but every single status is still showing in my query. What am I doing wrong?

project = "PROJECT_NAME" AND status in ("Data Collection", "Kick Off", "EHI Admin", Rollout, "QA/Testing")

Accepted answers

Jack Brickey

Hi @Trevor Kozar , welcome to the community.

So the example you provided above doesn't have any component of not in. Could you provide the example of the one that's not working? Below is an example of what should work.

project = "PROJECT_NAME" AND status not in ("Data Collection", "Kick Off")

in the above you should receive all issues in the project "PROJECT_NAME" except those currently in either "Data Collection" or "Kick Off" statuses.

All comments

Jack Brickey

Hi @Trevor Kozar , welcome to the community.

So the example you provided above doesn't have any component of not in. Could you provide the example of the one that's not working? Below is an example of what should work.

project = "PROJECT_NAME" AND status not in ("Data Collection", "Kick Off")

in the above you should receive all issues in the project "PROJECT_NAME" except those currently in either "Data Collection" or "Kick Off" statuses.

Trevor Kozar_4wsrxc

Thanks @Jack Brickey

Here is the full query: project = "PROJECT_NAME" AND component in ("COMPONENT_1") OR component in ("COMPONENT_2") AND status not in (Queue, Blocked, "Closed/Lost", "Monitoring Adoption")

And yet I'm still seeing each of the statuses I have listed as not to be shown.

Jack Brickey

Try one of these depending on your actual goal...

project = "PROJECT_NAME" AND component in ("COMPONENT_1", "COMPONENT_2") AND status not in (Queue, Blocked, "Closed/Lost", "Monitoring Adoption")

project = "PROJECT_NAME" AND component in ("COMPONENT_1") OR (component in ("COMPONENT_2") AND status not in (Queue, Blocked, "Closed/Lost", "Monitoring Adoption"))

Trevor Kozar_4wsrxc

@Jack Brickey Here is my exact query: project = "Strategic Programs" AND component in ("Direct Ordering") OR component in ("Direct Ordering + Transform") AND status not in (Queue, Blocked, "Closed/Lost", "Monitoring Adoption", Done)

Am I missing something? All of these statuses are still showing. Below is an example of the "Queue" Status still showing.

Screen Shot 2022-04-25 at 8.30.24 AM.png

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

filter