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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI all, can you use it for several tickets?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.