Sign in
Development questions

Write a SOQL query to fetch all OpportunityLineItem records along with the Product Name (Product2.Name), Pricebook Name (PricebookEntry.Pricebook2.Name), and Account Name (Opportunity.Account.Name).

DevelopmentMediumAccentureDeloitteCognizant

Traverse from the line item to each related record through relationship names.

soql
SELECT Id, Quantity, UnitPrice,
       Product2.Name,
       PricebookEntry.Pricebook2.Name,
       Opportunity.Account.Name
FROM OpportunityLineItem

This is a multi-level child-to-parent query, well within the 5-level limit.

soqlscenariochild-to-parentmulti-level

More Development questions