Query Issues that are linked to issues with certain fixVersion

Question

Hello,

We are working with SAFe Portfolio and therefore have the two issuetypes "Portfolio" and "Epic" in our project. To link them we use the Issue Link function "relates to". Now I would like to query with JQL all Portfolios that are linked to Epics which have a certain fixVersion "XYZ"

I Have seen some people using issue in linkedissuesOF but this does not seem to work.

Does anyone have any suggestions?

Thank you

Nora

Jack Nolddor [Sweet Bananas] · Answer

Hi Nora,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

1) Search 'Portfolio' issues linked to any Epics having a certain fixVersion "XYZ"

type = Portfolio AND issue IN linkedIssuesOf(' type = Epic AND fixVersion = XYZ ', 'relates to')

(*) Note that this is just an example, you must tune above query to fit your needs. e.g. Use issueFunction keyword instead of issue if you are using Script Runner

Using this app you can also query other issues relations, check:

* epicsOf()
* hasSubtasks()
* issuesInEpics()
* linkedIssuesOf()
* parentsOf()
* portfolioChildOf()
* portfolioParentOf()
* subtasksOf()

References:

* Official documentation

Hope this helps you to create awesome queries <3