Cascade List JQL using "any" as parent filter selection

[Steven Frazier]

Hi...I'm using rich filters for my dashboards and would like to be able to set a parent to "any" in a JQL filter so I don't have to manually enter each option and keep the query updated as the list is changed. Any suggestions on how to accomplish this would be appreciated.

[Walter Buggenhout]

Hi @Steven Frazier and welcome to the Community!

It is possible that I am not entirely catching your use case, but there is something odd to it. I assume that you would like to filter your dashboard by the second value from a cascading select field and are experiencing difficulties because those options only become available after selecting the first option.

That is how cascading select fields work. Although you could use cascadeOption() searches (see search documentation here), you will see no examples listed where the first option is empty. Simply because the child option is always tied to the selected parent. You might be able to set up smart filters to filter for each available child option, but I do not think that would be a scalable solution.

As far as I know, Rich Filters use the existing Jira custom fields to add them to a filter controller on the dashboard. Which means they behave as designed and that is how a cascading select field works: select a parent first to then unlock the (limited) list of child issues. If you don't need the parent to get to the child options, maybe you should reconsider the choice for a cascading select field for entering the data.

Hope this helps!

[Steven Frazier]

Hi Walter...I don't think I was clear in my description, so I'll attempt simplify. I want to create a filter for a cascading list that shows all parent options for that field without having to add each option to the query using "or". A sample of my workaround is below but this creates the need for me to update this query as new parent options are added...Does this help clarify my ask?

"216INV-Unit and Room" in cascadeOption(ICU) OR "216INV-Unit and Room" in cascadeOption(MedSurge-Ortho) OR "216INV-Unit and Room" in cascadeOption(RHC)

Thanks,