JQL compare with other issue field

[Fabian Toth]

Hi,

it is possible to request the following information by using JQL?

I have an issue "xyz" which have the Value "1.0" in the Field "fixVersion".

Now i can request all issues from type1 which have the version "1.0" with the JQL statement:

type = "type1" and fixedVersion = "1.0"

Is it possible to write not the version "1.0" in the statement but use instead the "version of the issue xyz"?

Something like:

type = "type1" and fixedVersion="thefixVersionOfTheIssueXYZ"

so that i use the value of the fixVersion field from the issue XYZ as parameter for my request?

Thanks for your help!

Fabian

[darylchuah · Accepted solution]

Hi Fabian

Currently the function is currently not available yet in JIRA which I believe there has something to do with nested JQL

Anyway, there is already an improvement request raised in here: https://jira.atlassian.com/browse/JRA-21936

Please feel free to vote on it to increase its popularity and add yourself as watcher in order to receive any latest updates from the developer and feedback from other user that is facing the same issue.

[Fabian Toth]

Hi Daryl, thanks for your answer!

[Filipe]

Hi,

This plugin:

https://marketplace.atlassian.com/plugins/pt.lt.lfcribeiro.jira.jqlLTFunctions

Lets you run a SQL as a parameter of a JQL functions (executeQuery(""))

You can have what you need as long you get your SQL statement.

Regards,