comparing list fields in jira queries

radai rosenblatt

im trying to build a query that returns issues where the contents of fixVersion(s) are not exactly the same as the contents of affectedVersion(s) - all issues where not all affected versions have been fixed, for example.

the naive solution of

affectedVersion = fixVersion

gets me

The value 'fixVersion' does not exist for the field 'affectedVersion'.

whats the correct syntax for comparing the contents of 2 list fields?

Haim Halbfinger1

Looked for a solution for this as well and came up with this filter creation.

I'm comparing the planned to the fixed (you can obviously do the same for affected instead).

Limitation is that you need to "maintain" the query for each release you are "fixing to"

("Planned for Version" in ("2.3.0") AND fixVersion not in ("2.3.0")) OR ("Planned for Version" in ("2.4.0") AND fixVersion not in ("2.4.0"))