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 · Accepted solution]

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!

[AGnieszka GRodzka]

Hi Walter.

That was very helpful. I used Filter Result gadget using query with 

issuekey in childIssuesOf(XXXX-YYYY)    phrase

where XXXX-YYYY is a key ID for the given Initiative.

I have a slight issues, receiving one list of Epics using above syntax for different Initiatives seperated with OR in my query. 

Could you suggest something here ?

Thanks

[Saurav Kumar Maharana]

Hi @Walter Buggenhout  - Please help me with this query.

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.

[bilyana_karayaneva]

HI all, can you use it for several tickets?