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

[Berny]

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 

[Trudy Claspill]

Hello @Berny 

To consolidate children and grandchildren, have you tried the portfolioChildIssuesOf() function documented here?

https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/

[Trudy Claspill]

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

[Charlotte Santos -Appfire-]

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_]

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

[Joseph Chung Yin]

@Berny -

I agreed with what @Trudy Claspill suggested.  Have you review the documentation setup associated with your JQL Search Extensions add-on to check if the tool provide JQL function that you can use in constructing your JQL statements?

I know that in our env we have ScriptRunner for Jira where it provide custom JQL function which allows us to fulfill similar content on your ask.  If can take a look at the add-on for your reference - https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?hosting=cloud&tab=overview

Out of the box, the JQL functions are limited.

Hope this also helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.