-
How to query Products by Opportunity?
How to query Products by Opportunity?
-
1 Reply
-
Hi Suraj,
You can use OpportunityLineItem to traverse from Opportunity to PricebookEntry and Product..something like this query :
SELECT Id, Name, Account.Name, (SELECT Quantity, UnitPrice, TotalPrice, PricebookEntry.Name, PricebookEntry.Product2.Family FROM OpportunityLineItems) FROM Opportunity WHERE Id = :YourOppId
Thanks.
Log In to reply.
Popular Salesforce Blogs
How to Hire the Best Commerce Cloud Consultant
Your online store needs more than just good products. It needs the right platform, the right strategy, and the right person to bring it all…
Ensuring a Seamless Customer Experience with Option Constraints | Salesforce CPQ
Salesforce CPQ provides an advanced and effective solution for companies looking to streamline their sales process and improve the customer experience. One of its key…
Why Salesforce Sales Cloud Is Essential for Businesses in 2025?
In an era where companies continuously seek ways to be innovative and stay ahead of the race, Salesforce Sales Cloud emerges as an imperative tool.…
Popular Salesforce Videos
Salesforce - What is customer service?
Believe it or not, your customers’ needs are also your business’s needs. Great customer service ensures customers are so happy, they’ll come back for more…
Salesforce Essentials
Watch this video to learn what customer relationship management (CRM) is and how CRM helps companies better engage with prospects and customers, streamline communications, and…
Create Custom Object and Tabs in Salesforce Lightning Experience
In this video, Sanjay Gupta Tech School explains how to create custom objects and tabs in Salesforce Lightning Experience. Watch this video and learn all…
