-
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
A Complete Introduction to Heroku
There are still minutes when I specify Heroku just to be met with a blank gaze. Which is really awful on the grounds that Heroku…
Migrate Attachments and Files Seamlessly with iSyncSF: Your Trusted Salesforce Data Migration Solution
Salesforce is a powerful CRM platform that allows businesses to store and manage a variety of data, including attachments and files. When migrating data from…
Salesforce Summer '25 Highlights
Summer is nearly here, and Salesforce's Summer '25 release update means there's more to look forward to than the sun and the beach. Whether you've…
Popular Salesforce Videos
What is Salesforce | Salesforce CRM Tutorial For Beginners | Salesforce Training
This Salesforce Training Video will help you understand what is a CRM ( Customer Relationship Management ), why we need Salesforce CRM and how some…
How To Assign Leads in Salesforce | Overview of 3 Main Lead Routing Solutions
Salesforce offers several options on how to automatically assign incoming leads to a suitable sales manager. But what to choose: out-of-the-box features, external AppExchange app,…
Prepare for TrailheaDX: Everything Salesforce Admins Need to Know
TrailheaDX is a one-of-a-kind virtual experience that connects makers, builders, doers, and dreamers looking to improve their Salesforce skillset. This year’s event includes exciting new…
