I would like to create a JIRA query to list all Epics under Initiative

AGnieszka GRodzka

I would like to create a JIRA query to list all Epics under Initiative, which will allow me to create a Two dimensional Dashboard gadget with all listed Epics under that Initiative, and its' statuses. When I use Epic Link on Yaxis, it does not list the Epics, but just one row with overal count of Epics under given status in columns.  Does Epic Link allow to present Epics in such way in that gadget ?

Walter Buggenhout

Hi @AGnieszka GRodzka  and welcome to the Community,

Epic link is the field that is used to link stories (tasks, bugs, ...) to an Epic. Those are the issues that in the hierarchy of your work are below an epic.

Initiatives are normally at the level above your Epics. And that link should be defined with the Parent link custom field.

That field comes with Advanced Roadmaps on either JSW Data Center or Cloud Premium. It is not clear from the tags on your question if you have that in place in your instance. Let's assume you do and you have e.g. an initiative JIRA-123 called "Building a hierarchical roadmap in Jira" and several Epics linked to it, you could query that like this:

"Parent Link" = JIRA-123

In that case, you could list all Epics from this one initiative, but I'd rather do that in a Filter results gadget.

If you want to display all initiatives and count of epics by status, you could try the following:

"Parent Link" is not empty and issuetype = Epic

You could represent that in a two dimensional issue statistics gadget with Parent Link and Status as dimensions.

Yet again, this would require you to have Advanced Roadmaps on your instance. That would enable to see a hierarchical view of all your work in the roadmap itself.

Hope this helps!