My goal is to give partner users access to records based on two field on the same object.
I use Sharing sets (From setup->communities settings->sharing sets)
On opportunity, I have two custom fields (Primary partner account and secondary partner account) which i want to based the sharing rules on them.
So i created two sharing sets, but still cannot see the secondary partner account records.
This one works:
While this one does not:
i.e Cannot see opportunity records where user.contact.acount == opportunity.secondary_partner_account__c
(Edit:You cannot apply two sharing sets on same profile)
Any ideas?
Please help:)
Best regards.
Best Answer
I solved this issue with help of some apex coding. Solution is based on OpportunityShare object which connects between users and opportunity records.