How to show all child issues of an Initiative?

[Ogden Rojas]

Our issue hierarchy is as follows:

Initiative >> Portfolio Epic >> Epic >> Story/Task/Spike, etc.

Question: Is there a query I can use to display all the children of an Initiative, up to and including the Story level? For instance, if I specify the Initiative ‘INIT-123’, the resulting query would display all of its childen, including Portfolio Epics, Epics, and Stories/Tasks/Spikes, etc.

Technical information:

• JIRA Data Center v9.12.11
• ScriptRunner v8.38.0

[Ogden Rojas · Accepted solution]

Looks like I found the answer after some more searching.

issue in childIssuesOf("INIT-123")

[Rekha Dayananda Babu]

Hi, We are using JIRA DC 9.12.28 and need a standard JQL query to display this data in dashboard which is crucial for customer to see the entire hierarchy under specific initiatives. Issue in ChildIssuesof() query is not giving any results. ScriptRunner Version: 8.56.0. Please suggest.