Compare Fix Version/s to Affects Version/s in JQL/Scriptrunner

[Corey Schulz]

Hi!

Using JQL I'd like to be able to perform a query sort of like this:

project in (project1, project2) AND affectedVersion != fixVersion

Of course, this query doesn't work. I'd like to know how to compare the Affects Version field to the Fix Version field in JQL. My company's got ScriptRunner, which from what I can gather is required to do this kind of query.

Is there a builtin method in ScriptRunner that will do this kind of comparison? I know that the:

issueFunction in expression(....)

won't do it. 

If not, what's the best way to go about making a custom issueFunction to compare these fields? I tried following these examples, but don't have much experience in Groovy unfortunately.

Thanks so much for your help!