3 Replies Latest reply on Apr 13, 2016 8:20 PM by user19752

    Filter Portal Request

    RishiKhanna

      Hi, I have a portal filter that currently does this:

      IsEmpty ( TempCustomer::gSearch ) or ( TempCustomer::gSearch = Left ( Customer::Name ; Length ( TempCustomer::gSearch ) ) )

       

      I got this from Adventure 2 EVS by Phil Caulkins, In the auto filtering search portal

       

      Table Setup:

      Customer

      CustomerId, Name

      Users

      User Id, Customer Id

       

      What I want to do is while I have the UserId as a global variable $$UserId apply this to the portal filter in order to return only the customers that they have access to from the users table and let them choose that.

       

      Any Ideas,

       

      Thanks,