Dynamic data retrieval for dashboard

[Archana Ravi]

I have created a filter listing down all the child issue types for a specific project and EPIC using "portfoliochildissuesof" function. I have configured a dashboard with the above specified filter as base and with rich filters / controllers added. I would like to filter down the data display in the dashboard based upon the Capability ID selected in my filter dynamically. Take for example when I select the capability ID, am expecting the dashboard to filter down all its associated child issues - Stories, Features and Stories. Please advise if there is any option using JQLs or Script runner addons

[Eduardo Anflor - MindPro]

Hi, @Archana Ravi 

Welcome to the community!

Unfortunately, I don't think you can meet these requirements with Jira's out-of-the-box functionalities since they do not drill down into data dynamically. If you are open to a marketplace solution, I recommend Mindpro Insights. I work at Mindpro, and I believe the app can help with this scenario.

It allows anyone to easily create and share dashboards with dynamic gadgets. It means when you click on a chart segment, the entire dashboard adapts to the filter. You can choose from over 50+ available.

The app also has a "Hierarchy" filter that displays the subitems in an indented way, and also the gadgets will respect the hierarchy selected:

You can select one or more items in the hierarchy filter.

I hope that helps.

Regards,

Eduardo

[Archana Ravi]

Thank you for looking into the request and responding to it.. Unfortunately we might not be able to use the Add-ins except for Script runner. Any other tactical solution will be very helpful

[Carlos Garcia Navarro]

Hi @Archana Ravi ,

Welcome to the Community! I'm not sure I understand the whole use case, but have you tried with the Rich Filter Controller? To find the children work items you can use the JQL clause:

issue in portfolioChildIssuesOf("<your work item Key ID>")

[Archana Ravi]

Thank you for checking @Carlos Garcia Navarro . Please find my use case below, any help / option is much appreciated!!
1. I want to generate a dashboard listing down Features, Stories, Test cases, defects linked to a specific Epic / Capability ID
2. I was able to achieve this result for single Capability ID using the above said JQL and rich controllers in the dashboard
3. I would like to extend it to multiple capability IDs, wherein upon selection of specific Capability ID in my rich filter controller gadget, I would like to display the features, Stories, defects, test cases linked to it.. 
A kind of nested query usage in dashboard rich filter controller gadget, please advise
Thanks again!!