JQL to retrieve all jiras linked to Initiative

[Renata]

Hi,

What is the best way to extract all jira's (Epics, Stories) linked to a single initiative?

I have Initiative ABC-111, which is linked to an epic ABC-112 via issuetype 'tracking the backport of'.

Epic ABC-112 is linked back to ABC-111 via issuetype 'backport is tracked by'

Epic ABC-112 has multiple Stories linked via Issues in Epic.

What would the JQL look like? I do not have an option to use childIssuesOf.

The only query I am able to use is issueFunction in linkedIssuesOf.

The JQL query I am using to extract all Epics within an initiative is:

issueFunction in linkedIssuesOf("issuekey = ABC-111","tracking the backport of")

but how do I get all Stories from each one of the Epics?

Please help.

Thank you

Renata

[Ste Wright · Accepted solution]

Hi @Renata 

To confirm:

• You have an issue type Initiative
• Epics are linked to Initiatives using issue linking - not the parent hierarchy (i.e you don't have Advanced Roadmaps)
• Stories are the children of Epics via the Epic Link

It looks like you have ScriptRunner or similar based on your use of issueFunction. If all of this is correct, I'd use:

issueFunction in linkedIssuesOf("issuekey = ABC-111","tracking the backport of") or issueFunction in issuesInEpics("issueFunction in linkedIssuesOf('issuekey = ABC-111','tracking the backport of')")

^ What it does is search for:

• All issues linked via the linked issue type to your Initiative and...
• All issues within Epics found via the original search

This is a little more limited than other functions as it targets Epic Link specifically, rather than all other link type possibilities.

Let us know if this works :)

Ste

[Renata]

Thank you so much for the query and your explanation. This is working like a dream.

[Sergej Grasmik]

Hello Renata,

try to use:

issueFunction in linkedIssuesOfAllRecursive("issuekey = ABC-111","tracking the backport of")

Cheers, Sergey

[Renata]

Thank you very much for your time Sergey. Unfortunately, that query has only returned my epics but the query provided by Stephen is working perfectly.