How can I compare the difference between 2 filters

[Giannis Michailidis]

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

[Bill Sheboy · Accepted solution]

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

[Chris Buzon]

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.