I currently have a filter searching for blank fields in the childOption (2nd field) of a cascading select field. The filter is as follows:
cf[ID] in cascadeOption("X", none)
but the limitation here is that I have to create a new line in my filter for every parentOption, which creates a maintenance nightmare should the options change down the road.
Is there any way that I can perform a wild-card search to look for a 'none' value in the childOption, regardless of the parentOption?
I was thinking something along the lines of:
cf[ID] in cascadeOption(*, none) //but this doesn't work
I've even approched the idea of creating a filter listing every alphabetical possiblity (e.g. cf[ID] in cascadeOption("A*", none) -- but that doesn't work either.
Thanks!