Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
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

Using JQL to exclude a field option Edited

So my users want 2 queues, one queue uses the input of one field and the other queue would use the input of another field, all in the same project.  So right now I have the first queue setup where it pulls from a field and sorts it into that queue, and the same for the second queue. These all work great, but the second queue is based on a response to a field that both use, however, they want the tickets to be removed from the first queue and go to the second one, not show up in both. The problem is I cannot seem to be able to exclude only the specific inputs from the second field in the first queue to get it to drop from that queue.

Also for the first field it is a multi selection, and for the second field it is a single drop down menu which has about 7 options but only 2 of them sort into the second queue.

What I have for queue 1 looks like this and it says the queue is empty, which it should not be.
issuetype = "Project" AND resolution = Unresolved AND "Field 1" in (Option 1, Option 2, Option 3) AND "Field 2" != ("Option 6", "Option 7")

If I exclude `AND "Field 2" != ("Option 6", "Option 7")` it works normally but obviously has the tickets that are in the second queue.

 

For queue 2 I have, this works as expected:
issuetype = "Project" AND resolution = Unresolved AND "Field 2" = ("Option 6", "Option 7")

I hope this is clear and someone may be able to see what is going on. I can provide more context as needed as well.

3 answers

1 accepted

1 vote
Answer accepted

So I fixed it by being more specific on my queries vs trying to exclude the other options, I think it looks messier and is harder to understand but basically I included an empty field for the the second field option and the specific one it could be given and just added those as AND statements.

2 votes
Jack Community Leader Jun 08, 2021

Haven’t tested but should it be …  "Field 2" not in ("Option 6", "Option 7")

So I have done that and it returns that the queue is empty, which it should not be, I have multiple tests and only 2 should be excluded but its not finding the other 10 or so that fit the other conditions. For some reason if I exclude those choices it seems to exclude all of them.

I haven't tested it, but it should be... "Field 2" is not included ("Option 6", "Option 7")

Suggest an answer

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

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

196 views 6 7
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