
Announcements
I have 3 entities:
1. Products(Custom Entity)
2. Contacts (oob Entity)
3 Locations(Custom entity)
They are linked in the following way:
Each product has a contact(lookup to contact entity).
Each Contact is associated to Location(Lookup to location entity).
Issue: I want to show a logged in portal user, the list of products that are linked to contacts who are based in the same location as the logged in user.
For example:
product 'A' is create by contact 'X' who is based in 'Canada'
Product A--> Contact X--> Location Canada
Product B --> Contact Y--> Location Canada
Product C--> Contact Z--> Location Canada
Product D --> Contact F--> Location USA
So, when Contact X navigates to a particular view/entity List on portal.. They see Products A,B,C as they are created by contacts based in location 'Canada'
Can someone please suggest how can I do that? I am not able to find good resources/Answers in other Forums