Comparing custom "version" field to

[sniederb]

Our setup has a custom versions field "Test in versions" (Version Picker (multiple versions)). I'm looking for a JQL expression to find issues which have an entry in "Test in versions" which is NOT present in fixVersions.

fixVersion not in "Test in versions"

results in 

Operator 'not in' does not support the non-list value '"Test in versions"' for field 'fixVersion'.

Any ideas? 

[Petter Gonçalves · Accepted solution]

Hello Simon,

Currently, it is not possible to directly compare two custom field values using only a JQL query, but we have a feature request to implement it for Version custom fields:

- Add ability to compare version fields using JQL

Feel free to vote and watch the suggestion to increase its priority and also receive notifications about any updates.

Additionally, the IssueFunction in expression parameter provided by Scriptrunner plugin can help you to achieve this functionality. Please, check the documentation below for more details:

JQL Functions from ScriptRunner

Let us know if this option works for you and have a nice day! :)