JQL to get details of linked parent initiatives

[Ron Becker]

With a query we search for all Epics in a project. At the same time we would like to retrieve the linked parent and some details of the parent initiatives.

- Can this be achieved when parents are linked via issue links (Implements).

- Can this be achieved when parents are linked via the Parent Link field from Portfolio?

[Stephen Wright _Elabor8_ · Accepted solution]

Hi @Ron Becker

Using JQL without an add-on, you can do some searching - for example:

• issueLinkType: This allows you to search for all issues within one link type
• issuekey in parentIssuesOf("ABC-123"): This would allow you to search for the parent of one specific Epic. See more details on Portfolio JQL on this page

^ This returns all the results though, rather than a subset. If you want to locate all the parents of a group of Epics, you need to be able to implement a sub-query into the JQL search, and you'll need an add-on for this such as ScriptRunner.

With ScriptRunner, you can embed the sub-query, such as:

issueFunction in portfolioParentsOf("project = ABC and issuetype = Epic")

^ This searches for all Initiatives above which are parents of all the Epics in project ABC. Similarly with linked issues you could have:

issueFunction in linkedIssuesOf("project = ABC and issuetype = Epic","implements")

----------------------------

Just to clarify, this would find just the Initiatives themselves. You can have both on one search filter by adding...

OR project = ABC and issuetype = Epic

...to end of the query.

Ste

[Seb Sidbury]

Just to add to Ste's helpful note, for anyone looking to solve this challenge in Jira Cloud, the portfolioParentsOf() function is not currently available in ScriptRunner for Jira Cloud as the API to implement this function does not exist in Jira Cloud. 

However linkedIssuesOf() is included in ScriptRunner for Jira Cloud, as well as in Enhanced Search for Jira Cloud for those not requiring the scripting functionality of ScriptRunner.

Seb (Adaptavist)

[Ron Becker]

Thanks for your help. Scriptrunner solved the problem. 

[Jack Nolddor _Sweet Bananas_]

Hi Ron,

In addition to previous responses you can achieve the desired results using i.e. JQL Booster Pack as well, instead of using Script Runner if your application is self-hosted.

Some examples here:

- Can this be achieved when parents are linked via the Parent Link field from Portfolio?

issue in portfolioParentOf("project = XXXX and type = Epic")

- Can this be achieved when parents are linked via issue links (Implements).

issue in linkedIssuesOf("project = XXXX and type = Epic","implements")

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

Kind regards