Hello,

I have an issue with a trigger now working in Lightning but works as expected in Classic.

I have a simple trigger which validates whether there's a contact role already in an Opportunity or not. If none, then will create one.

Example I have:
list<OpportunityContactRole> ocr = [select id from OpportunityContactRole where id in : oppList];
if there are 2 Contact Roles on the Opportunity the ocr.size() should return 2.. But on lightning, this always return 1..

The purpose of my trigger is when the Opportunity is created from the Opportunity Tab and account is selected, it will automatically create an Opportunity Contact Role based on the Contact on the Account.

However, when we do this under Contact, this automatically create 1 Contact Role (Standard SF function) and another 1 contact role from my trigger.

To avoid that, I figured I needed to do a validation before I create the Contact Role.

Here's my trigger.
 

public class SG_OpportunityTriggerHandler{
    
    //This will create Opportunity Contact Role
    public void NEW_OCR(list<Opportunity> OppList){
        //THIS PART DOES NOT WORK IN LIGHTNING
        map<id,OpportunityContactRole> ocrMap = new map<id,OpportunityContactRole>();
        for(OpportunityContactRole ocr : [select id,opportunityId,contactId  from OpportunityContactRole where opportunityId in : OppList]){
            ocrMap.put(ocr.opportunityId,ocr);
        }
        
        list<OpportunityContactRole> newOCR = new list<OpportunityContactRole>();
        
        for(opportunity opp : [select id,account.Contact__c,account.Person_Account__c from opportunity where id in: OppList]){
            if(opp.account.Contact__c != null && opp.account.Person_Account__c == true){
                if(!ocrMap.containsKey(opp.id)){
                    OpportunityContactRole ocr = new OpportunityContactRole();
                    ocr.contactId = opp.account.Contact__c;
                    ocr.opportunityId = opp.id;
                    ocr.IsPrimary = true;
                    newOCR.add(ocr);
                }
            }
        }
        
        database.insert(newOCR);
    }

}