cascadeOption() function in JIRA JQL

[Genesis_Lebron-Coll]

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!

[Marc -Devoteam-]

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]

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