Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL Query for status = new is listing all status

Hi everyone 

I am working on a filter for Queues where Queue have to get only those issue where the status on the issues are New 

status = NEW

everything else is working perfect on the JQL for some reason I get all Status issue. 

here is my JQL.

Project = "External Customer Support" AND status = New AND request-channel-type = portal OR request-channel-type = jira AND "RS Product" in ("Hardware", "Payment Portal") OR "Portal Product" in ("Hardware", "Payment Portals:") AND assignee is EMPTY

thanks in advance. 

 

2 answers

1 accepted

3 votes
Answer accepted

Hi @Muhammad 

It looks like you need to add in some brackets here to isolate your ANDs and your ORs. Currently, your statements after the two ORs will be pulling in tasks which aren't in the New status, but they satisfy the OR requirements

I'm not sure exactly what you're wanting to be displayed, but perhaps this will fix your issue:

Project = "External Customer Support" AND status = New AND (request-channel-type = portal OR request-channel-type = jira) AND ("RS Product" in ("Hardware", "Payment Portal") OR "Portal Product" in ("Hardware", "Payment Portals:")) AND assignee is EMPTY
3 votes

Hi @Muhammad , 

 

it's because the OR statement will break your query : it gives you ALL tickets with "request-channel-type = jira" and ignores the AND around it. To fix it you need parenthesis : 

Project = "External Customer Support" AND status = New AND (request-channel-type = portal OR request-channel-type = jira) AND ("RS Product" in ("Hardware", "Payment Portal") OR "Portal Product" in ("Hardware", "Payment Portals:")) AND assignee is EMPTY

 

Let me know if this helps, 

 

--Alexis

Hi @Alexis Robert  and @Callum Carlile _Automation Consultants_ 

thank you so much both answers worked for me.

Like Callum Carlile likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Next level incident management in Jira Service Management

Hello Atlassian Community! We’re thrilled to announce some exciting changes to incident management in Jira Service Management Cloud, in order to give your teams extra muscle during incidents, and ...

1,616 views 20 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you