Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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
Callum Carlile Community Leader Mar 29, 2021

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

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

ThinkTilt is joining the Atlassian Family!

This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...

402 views 19 23
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