Hello,
I'm searching for a solution about faceted search behaviour for null values within cascading LOV.
For example i have 2 facet →
- PX_FACET1 (Included null option)
- PX_FACET2 (Included null option & cascading item is PX_FACET1)
In that condition when i select the null option from facet1 , i would expect that should filter related column from facet2. But i get this error instead →
Currently i have to close the cascading, i'm using hide zero count values feature but that approach ending up with too many unnecessary values & count computations for FACET2 which decreasing performance. Also hiding zero count values not nice for UX since when user open the page it loading all facet values initially then hiding it (you can see all on UI initially.)
Any suggestion about this ? I can change my approach or any kind of solution needed.