I would like to create a JIRA Query to give me the count of EPICs listed under Initiative

[Saurav Kumar Maharana]

There is a project that has multiple initiatives (let's say there are 10 initiatives). Now each initiative has certain number of epics (let's say few have 2 & few have 3). I need to write a query that will display a list of Initiatives under the project and the count of EPICs each of these initiative's have.

[Mark Segall]

Hi @Saurav Kumar Maharana - Unfortunately this is not possible to dynamically get this information without a marketplace app. 

Depending upon whether your instance is server/DC or Cloud, you'd need to execute a query like this:

Server/Data Center

(issue in childIssuesOf(ABC-001) OR issue in childIssuesOf(ABC-002) OR issue in childIssuesOf(ABC-003)) AND issueType = Epic

Cloud

(issue in portfolioChildIssuesOf(ABC-001) OR issue in portfolioChildIssuesOf(ABC-002) OR issue in portfolioChildIssuesOf(ABC-003)) AND issueType = Epic

Include the Parent Link field as a column in your results.

Unfortunately, another limitation is that you can't do any dashboard activity against Parent Link, so you'd need to export the results to csv and perform a pivot in your spreadsheet app of choice.