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?
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
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) ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.