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