JQL compare with other issue field

Fabian Toth October 28, 2013

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

2 answers

1 accepted

1 vote
Answer accepted
darylchuah
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
October 28, 2013

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 October 28, 2013

Hi Daryl, thanks for your answer!

0 votes
Filipe February 25, 2014

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,

Suggest an answer

Log in or Sign up to answer