You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
I want to create a query in which the results will be the difference between 2 filters
specifically, Ι have created the custom field vendor assignment team which updates the field assigned team (by post function). in few cases it does not work and there are a discrepancies between these two fields.
that's why I am trying to built a query (below) to find these issues but no results (error message)
issuetype in ("Adhock Request", Bug, "Change Request", "Frs Leftover", Incident, "Support Request") AND "Vendor Assigned team[Dropdown]" is not "Assigned Team[Group Picker (single group)]" ORDER BY created DESC
If I understand your question, you want to compare two different issue fields with JQL.
That is not possible with out-of-the-box features: JQL is not a SQL. Your possible work-arounds depend upon how often you need to perform this query and if you have (or can buy) addons:
Kind regards,
Bill
You can look to see if the field is empty, which might work too.
...AND ("Vendor Assigned team[Dropdown]" IS EMPTY or AND "Vendor Assigned team[Dropdown]" = <name of that group>)...
The syntax here can be cumbersome.
You could also try doing something like make 2 filters and compare them
filter = "Filter 1" and filter != "Filter 2"
The exact use case here is a bit confusing, so I may be misunderstanding your needs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.