Search multiple options in a cascade type field

Jon_4n6t23

I have a field that is a cascade type field. it has 5 main options and each of those has 1-3 additional options. i want to do a search based on 3 of the approximately 15 different options but it will only let me select "any" for the parent options. What i want to do is search across 3 of the different parent options. 

 

currently it looks like this with one of them selected 

project = ES AND issuetype = Epic AND status in ("OPEN Loaded", Open) AND "Pmt Term" in cascadeOption(10431, 10432)

 

and the other ones im trying to search at the same time have codes.

(10428, 10429)

(10425, 10426)

 

I tired to combine them but it said the below. 

 

SearchBasicSwitch search results viewIncorrect number of arguments specified for the function 'cascadeOption'. Usages: cascadeOption(parentOption), cascadeOption(parentOption, childOption), cascadeOption(parentOption, "None").

 

Are there any wild card characters i can use or does anyone else have an idea? 

Andy Heinzer

Hi Jon,

I think I can see the confusion over the usage of this JQL function here.  While the cascadeOption() function lets you pass multiple values, it's not like other JQL functions that use the IN operation where you can define multiple specific values in the same function.  Instead the multiple values that are accepted by that function are in regards to a single parent option and single child option per use of that specific function.

Hence you were probably formatting your failing query in a way such as

project = ES AND issuetype = Epic AND status in ("OPEN Loaded", Open) AND "Pmt Term" in cascadeOption(10431, 10432, 10428, 10429, 10425, 10426)

But instead I believe you will need to format it like this instead:

project = ES AND issuetype = Epic AND status in ("OPEN Loaded", Open) AND ("Pmt Term" in cascadeOption(10431, 10432) OR "Pmt Term" in cascadeOption(10428, 10429) OR "Pmt Term" in cascadeOption(10425, 10426))

The documentation on cascadeOption(), would seem to concur that you can only specific one parent and one child value per use.

I hope this helps.

Andy