cascadeOption() function in JIRA JQL

Question

I am using AppFire's 'Dashboard Hub' app and trying to build out 6 bar charts that pull data from a custom field using a JQL. The field is a Cascading field, so I have parent and child options users select. My goal is to have one bar chart pull in data that show all the Parent selections with no children selections. Then have 5 separate bar charts that will drill down each parent selection and display the children-selections for each parent.

It has been a challenge to write a JQL using the cascadeOption("") operand. I keep getting an error when I place a parent name in the "" i.e. cascadeOption("Requirements").

If anyone has any experience with this specific field or other suggestions on how to pull parent and child specific data for 6 different bar charts I would be so grateful.

Thank you!

Ivan Garcia _Appfire_ · Answer

Hi @Benjamin

This is Ivan from Appfire

Thanks for providing our Support Channel, as it really is the best and fastest way for us to help. @Genesis_Lebron-Coll do you mind opening a support request for us? We'd love to help!

Thanks

Marc -Devoteam- · Answer

Hi @Genesis_Lebron-Coll

Welcome to the community.

What level is "Requirements" in the cascading field parent or child.

If it is parent, you need to use JQL like:

<name of cascading filed> in cascadeOption("Requirements", none)

Benjamin_tmh9yg · Answer

HI @Genesis_Lebron-Coll ,

I have not encounter this issue myself. Usually, the fastest way for Marketplace Apps answer, I directly to their support. Appfire, in my experience, has fairly good support and response times.

Here's the link:

https://marketplace.atlassian.com/apps/1223898/dashboard-hub-pro-charts-reports-time-in-status-for-jira?tab=support

Here's the documentation on the cascade option. Check the examples in the doc.

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#cascadeOption--