Portal filtering - Show all records
I am facing the following problem:
Let's assume I have products of different color, size and price.
I want to show in a portal the records that might be suitable for the customer. Let's say color is not mandatory and I want to list all the products with the matching color and also all the matching products when color is not defined in a request.
So I have the below calculation in the the portal setup:
Case ( not IsEmpty ( Requests::color ) ; PatternCount ( Requests::color ; Products::color ) ; "*" )
Unfortunately the * symbol doesn't work here as a wildcard for "anything".
Many thanks in advance!