JQL query to retrieve all the epics from multiple capabilities needed

Harihara Prasath V

JQL query to retrieve all the epics from multiple capabilities needed.  I have a query which can retrieve all the epics from single capability however my need is to create a jql which can retrieve all the epics from multiple capabilities.  Can anyone help?

Query for retrieving epics from single Capability.

project = Key AND issue in linkedIssues(<Capability No.>, "is parent of")

Thanks in advance.

Regards,

Harihara Prasath.

Trudy P Claspill

Hello @Harihara Prasath V 

Welcome to the Atlassian community.

Based on the documentation for the "linkedIssues()" function you must be putting an Issue key into the place where you have "<Capability No.>".

You said you are trying to retrieve Epics. Are you using generic issue linking to link the Epics to the Capability issues? The Capability issues are not child issues under the Epics?

If you are indeed using generic issue linking, then to accomplish your goal you will have to add criteria to your query thus:

project = Key AND (issue in linkedIssues(<Capability No.>, "is parent of") OR issue in linkedIssues(<Capability No.>, "is parent of") OR issue in linkedIssues(<Capability No.>, "is parent of"))

Adding a new OR criteria for each Capability issue.

 

If you have access to third party apps/plugins that extend JQL issue search syntax, then there may be alternatives available. For instance ScriptRunner adds capabilities to find linked issues based on a subquery.

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/issue-links#linkedissuesof