AnsweredAssumed Answered

Portal filtering - Show all records

Question asked by KrisztianG, on Jul 26, 2014
Latest reply on Jul 27, 2014 by KrisztianG,


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!