JQL compare with other issue field


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!


2 answers

1 accepted

1 vote
Daryl Chuah Atlassian Team Oct 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.

Hi Daryl, thanks for your answer!


This plugin:


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.


Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

700 views 6 13
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you