A JQL Query / filter needed for displaying all items under an Initiative

Question

Hi

We are looking to create a dashboard gadget which consolidates all children and grandchildren issues underneath an initiative.

As per below snip, Level 0 FCI- 28 CI Team - BAU is the item I am creating the dashboard for. We then have five disciplines under this Level 0 item which I want to create a filter where I have all the items contained in each discipline but when I report in the dashboard, I want it to group at the discipline level rather than it grouping back to the epic. Can this be done and how?

I have Jira Premium with the Custom Charts addon and also the JQL Search Extensions addon.

Thank you

Charlotte Santos -Appfire- · Answer

Hi @Berny

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all children and grandchildren of initiatives:

issue in childrenOfIssuesInQueryRecursive("project='FCI' and type=Initiative")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Danut M _StonikByte_ · Answer

Hi @Berny,

This cannot be achieved by using Jira's JQL. However, you can do this by using the Work Breakdown Structure (WBS) gadget offered by our Great Gadgets app.

This gadget displays the issue from a filter or a JQL in a tree hierarchy in form of Epics > Stories > SubTask along with their status. If you have Jira Advanced Roadmaps installed, it can also display the Initiatives on top of epics.

All you have to do, is to configure the gadget with saved filer or JQL that returns all the issues to be displayed, and it will do the grouping for you. See also more examples of use for this gadget in the articles from our blog.

Hope this helps. If you have any questions about it, you can contact support@stonikbyte.com.

Danut

Trudy P Claspill · Answer

JQL Search Extensions also provides the capability. Refer to its documentation here:

https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209353/Jira+Hierarchy+Advanced+Roadmaps+JQL+Functions