Referencing product2 record from Opoortunity object

Question

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;

}

sridhar bachu · Answer

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

Referencing product2 record from Opoortunity object

Apex

Aprendizaje relacionado

Más ayuda