2 Replies Latest reply on Jul 27, 2014 10:50 PM by KrisztianG,

    Portal filtering - Show all records

    KrisztianG,

      Title

      Portal filtering - Show all records

      Post

           Hi!

           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!