AnsweredAssumed Answered

Filter Portal Request

Question asked by RishiKhanna on Apr 11, 2016
Latest reply on Apr 13, 2016 by user19752

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,

Outcomes