Can I require both fields of a cascading custom field using JQL?

[lukec]

Hi, 

If I use this: 

"Product Category" not in cascadeOption(none)

I find some issues that do not have a value in the second drop down. 

How can I filter, with JQL, to see only issues that have both drop downs with a value in them?

[Pramodh M · Accepted solution]

Hi @lukec 

First, collect all the parent options in the Cascade field "Product Category"

Then follow the JQL to get the issues where both fields are not empty

project = "projectKey" AND ( !("Product Category[Select List (cascading)]" in cascadeOption("parentOption1", none)) AND !("Product Category[Select List (cascading)]" in cascadeOption("parentOption2", none)) AND !("Product Category[Select List (cascading)]" in cascadeOption("parentOption3", none)) )

And it goes on till you have covered the parentOptions.

This will give the expected results

Please let me know if this works

Thanks,
Pramodh

[lukec]

Awesome thank you

[Julius Zatroch]

Hi @Pramodh M '

But how to search if we have many parentOptions?   I cannot write JQL 70lines long with all options....

Any option use "wildcard" or  something like cascadeOption(any,none)  ?