JQL Query for status = new is listing all status

[Muhammad Akram Sharifi]

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. 

[Callum Carlile _Automation Consultants_ · Accepted solution]

Hi @Muhammad Akram Sharifi 

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

[Alexis Robert]

Hi @Muhammad Akram Sharifi , 

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

[Muhammad Akram Sharifi]

Hi @Alexis Robert  and @Callum Carlile _Automation Consultants_ 

thank you so much both answers worked for me.