function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
aparna d 1aparna d 1 

Email notification using triggers

Hi Everyone,

I am struck to display opportunity owner in email notification using triggers. Below is my code,  I am getting error ple any one give me solution 
for(sObject m : trigger.new)
        {
            Miles__c mile = (Miles__c)m;
            mileCaseid.add(mile.Case__c);
            mileOppid.add(mile.Opportunity__c);
            // Miles__c oldmile = (Miles__c ) trigger.oldMap.get(mile.id);
        //}  
        
        map<id,Case> casemap =new map<id,Case>();
        list<case> lstcase = [select id,CaseNumber,Revision__c,Priority from case where id in : mileCaseid AND RecordTypeId = :Caserectypid ];
       System.debug('lstcase'+lstcase);
        map<id,opportunity> oppmap = new map<id,opportunity>();
        list<opportunity> lstopp = [select id, name,Owner.Name,Region__c from opportunity where id in : mileOppid];
          System.debug('lstopp '+lstopp ); 
          if(!lstcase.isempty())
       { 
             for(case cse:lstcase ){
                casemap.put(cse.id,cse);
                }
    //   if(!lstopp.isempty())
     // { 
            for(opportunity opp:lstopp){
                oppmap.put(opp.id,opp);
            }    
            for(Miles__c mm : [select id,name,Status__c from Miles__c] ){
           //     Miles__c mile = (Miles__c)m;
               
                string oldmile  = mm.Status__c ;
              //  Miles__c oldmile = (Miles__c ) trigger.oldMap.get(mile.id);
                
                if(mile.Status__c == 'Completed' &&  mile.Status__c != oldmile && mile.Case__c!= null && mile.RecordTypeid ==  Milerectypid  )
                {
                    //system.debug('milestattusold'+oldmile.Status__c);
                    milemap.put(mile.id,mile);
                    string sub =  casemap.get(mile.Case__c).CaseNumber + mile.Opp_Inquiry__c+'Notification of Milestone Completion';
                    mail.setSubject(sub);
                    
                       mail.setHtmlBody( 
                       '<html lang="en">'+
                       '  <head>' +
                        '    <meta charset="utf-8"/>' +
                        '    <meta name="viewport" content="width=device-width" />' +
                        '    <br/>' +
                        '    <br/>' +
                        '    </head>' +
                        '    <br/>' +                 
                      
                        '   <b>Inquiry Number: </b>' + (String.isBlank(mile.Opp_Inquiry__c) ? '' :  mile.Opp_Inquiry__c) +
                        '    <br/>' +
                        '   <b> Case : </b> ' + (String.isBlank(casemap.get(mile.Case__c).CaseNumber) ? '' : casemap.get(mile.Case__c).CaseNumber ) +
                        '    <br/>' +
                        '   <b> Case Revision :  </b>' + (String.isBlank(casemap.get(mile.Case__c).Revision__c) ? '' :  casemap.get(mile.Case__c).Revision__c) +
                        '    <br/>' +
                         
                      '  <b>Opportunity Owner: </b>' + (String.isBlank(oppmap.get(mile.Opportunity__c).Owner.Name) ? '' :  oppmap.get(mile.Opportunity__c).Owner.Name) +
                       '    <br/>' +
                                                 
                        ' </html>'    
                       ) ; 
                     }
                  }