Apex Code Development You need to sign in to do that
Don't have an account?
Jeff G How to Access Opportunity's Products from Outside Opportunity?
Hi All,
I am creating a custom object that mirrors the information of an Opportunity object. I also want to copy over information related to the Opportunity's products (Opportunity Line Items) into custom fields, but I can't seem to access them.
I have a lookup relationship from the custom object to Opportunities, and there already exists a lookup relationship from Opportunity Products to their associated Opportunities. Unfortunately, I can't find a way to establish a lookup relationship for the other way around: from the Opportunity to the Opportunity Product. This prevents me from accessing each individual product I've added to a certain Opportunity.
Does anyone have any suggestions? Thanks!
Best,
Jeff
I am creating a custom object that mirrors the information of an Opportunity object. I also want to copy over information related to the Opportunity's products (Opportunity Line Items) into custom fields, but I can't seem to access them.
I have a lookup relationship from the custom object to Opportunities, and there already exists a lookup relationship from Opportunity Products to their associated Opportunities. Unfortunately, I can't find a way to establish a lookup relationship for the other way around: from the Opportunity to the Opportunity Product. This prevents me from accessing each individual product I've added to a certain Opportunity.
Does anyone have any suggestions? Thanks!
Best,
Jeff
As you said your custom object has lookup field opportunity. You can create a map something like this.
list<Opportunity>Opplist =[select id,fieldname,(select id,fieldname from OpprtunityLineItems) from opportunity ];
Map<string,Opportunity> MapOfOpportunity = new Map<string,Opportunity>();
for(Opportunity OppObj : Opplist){
MapofOpportunity.put(Opp.id,Opp);
}
List<OpportunityLineItem> OppLineItems =MapOfOpportunity.get(customField(lookup Opportunity)).OpportunityLineItem; //Childs of that opportunity.
In this way you can access the Opportunity's Products.