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

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.

Accepted answers

Callum Carlile _Automation Consultants_

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

All comments

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

Callum Carlile _Automation Consultants_

Hi @Muhammad Akram Sharifi

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

Muhammad Akram Sharifi

Hi @Alexis Robert and @Callum Carlile _Automation Consultants_

thank you so much both answers worked for me.

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-service-management