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

AGnieszka GRodzka October 29, 2021

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 ?

2 answers

1 accepted

1 vote
Answer accepted
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 29, 2021

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 November 2, 2021

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 October 11, 2022

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
Contributor
September 28, 2023

HI all, can you use it for several tickets?

0 votes
James Ungerer
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 21, 2024

Has anyone got JQL code to pass multiple keys into that function?  I was thinking to create a filter of the initiatives and use that to display on a Kanban board, then I can use Epics as swimlanes.

Suggest an answer

Log in or Sign up to answer