Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,556,704
Community Members
 
Community Events
184
Community Groups

How can I compare the difference between 2 filters

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

2 answers

1 accepted

0 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 04, 2023

Hi @Giannis Michailidis 

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:

  • need one time
    • export the issues to a spreadsheet (or other tool) and perform the comparison there
  • need often, and have money to spend on addons
    • investigate the Atlassian Marketplace for JQL addons which add this query capability
  • need often, and do not have money to spend on addons
    • use a dashboard and the two-dimensional filter gadget to display the items which match (or do not) in a table
    • investigate using automation rules to detect this condition and mark the issues (e.g., with a comment or custom field) to indicate a mismatch.  This indicator could then be searched with JQL.

Kind regards,
Bill

0 votes
Chris Buzon
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 04, 2023

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events