Drop Down Portal Filtering
I have been trying something like the 3rd solution listed here:
But my calculation isn't exactly working correctly. It works on empty values and when I pick the first category. When I pick the subcategory it doesn't do anything until I delete whatever is in the first category.
In other words, when nothing is inputted all items show, when the first category is inputted the the list filters correctly. When the subcategory is inputted after that, the list does not filter anymore. If I delete what is in the first category, but leave the subcategory the same, then it filters correctly.
Here is my calculation I am using for the portal filtering:
IsEmpty ( INVENTORY::globalCat ) and IsEmpty ( INVENTORY::globalCatSub ) ;
( ( INVENTORY::globalCat = inventory_PRODUCT_search::category )
and ( not IsEmpty ( INVENTORY::globalCat ) ) ) ;
( ( INVENTORY::globalCatSub = inventory_PRODUCT_search::catSub )
and ( not IsEmpty ( INVENTORY::globalCatSub ) ) ) ;
; 0 )
Inventory is the layout table, and Product is the portal table
I've been trying to figure this out for a while, and can't seem to go at it anymore myself. Any help is appreciated. Thank you!