Skip to main content
Topics#ApexGlenn Daly 的问题
Glenn Daly (Pod Point) 提问于 #Apex
2016年10月10日 11:33

Referencing product2 record from Opoortunity object

I'm trying to reference the product2 name from an opportunity record. However it's giving me this error and not allowing me to save the code.

"Invalid foreign key relationship: Opportunity.opportunitylineitem"

How should I be referencing this field?

global class OpOwnerOldService_Scheduled Implements Schedulable

    {

        global void execute(SchedulableContext sc)

        {

            sendEmailtoOppOwner();

        }

        public void sendEmailtoOppOwner()

        {

            List<Opportunity> listOpportunity = new List<Opportunity>();

            listOpportunity = [SELECT Id, OwnerId FROM Opportunity WHERE Id In (SELECT OpportunityId FROM OpportunityLineItem WHERE Product2.Make_unavailable_for_opps_and_proposals__c = TRUE)];

            for(Opportunity opp : listOpportunity)

            {

               Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();

mail.setTargetObjectId(opp.OwnerId);

mail.setReplyTo('glenn.daly@live.com');

mail.setSenderDisplayName('Salesforce Support');

mail.setSubject('Historic Service attached to current opportunity : '+ opp.  );

mail.setPlainTextBody(opportunity.Id +' has been created.');

mail.setSaveAsActivity(false);

                

Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });

            }

            update listOpportunity;

        }

    }
1 个回答
  1. sridhar bachu (NTT Data)
    2016年10月10日 14:17
    Hi Glenn,

    I tried your query at my sandbox works fine, didn't throw any error. Something is missing, i think so there is no wrong in SOQL.

    I tried this 

    List<Opportunity> a = [select id, ownerId from opportunity where id in (SELECT OpportunityId FROM OpportunityLineItem WHERE Product2.family='Cloud')];

    Good Luck. Check security settings. As we know salesforce error description not always so precise.

    Regards

    Sri
撰写回答...
0/9000