comparing list fields in jira queries

radai rosenblatt January 20, 2014

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?

1 answer

0 votes
Haim Halbfinger February 2, 2014

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"))

Suggest an answer

Log in or Sign up to answer