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?

Ste Wright

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