Scenario: Two custom Objects having a MD relationship as Opportunity Mgmt (Master) - Deal (Detail). I have a Standard User Lookup Field "Solution Lead" in Deal Object. The OWD for Opportunity Mgmt is "Private". The Opportunity Mgmt records will be shared with the Solution Leads via Apex Managed Sharing.
I would like to Filter the Deal Records based on the Logged on User. Show only Deal records on which the Logged On user is the "Solution Lead". How do I achieve this?