You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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 ?
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!
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 ?
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.