Statuses filtered out still showing

[Trevor Kozar]

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") 

[Jack Brickey · Accepted solution]

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]

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")

or

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]

 @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. 

 

[Jack Brickey]

Hi @Trevor Kozar ,

If you were to add Components to your columns then it might help understand what is going on here. I think your issue asked to do with the lack of parentheses. Can you explain exactly what your goal is here so that I might create the proper JQL.

For example, if you want to find every issue in your project that:

has "Direct ordering" as a Component regardless of status 

OR

has "Direct Ordering + Transform" as a Component only if the status is one of: Queue, Blocked, "Closed/Lost", "Monitoring Adoption", Done

the your JQL should look like this...

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

[Trevor Kozar]

Hey @Jack Brickey my goal is to find all tickets within the Strategic Programs project that have a component of Direct Ordering or Direct Ordering + Transform and are NOT in the statuses of Queue, Blocked, Closed/Lost, Monitoring Adoption, Closed or Done. 

Here's what I just entered based off of your last response (thank you for your help by the way) and it still seems it's returning the undesired statuses. Maybe I'm still misunderstanding. 

[Jack Brickey]

ok so based on your goal try this...

project = "Strategic Programs" AND component in ("Direct Ordering", "Direct Ordering + Transform") AND status not in (Queue, Blocked, "Closed/Lost", "Monitoring Adoption", Done)

[Trevor Kozar]

That did the trick, thank you so much for our help and patience! @Jack Brickey 

[Jack Brickey]

Glad to assist