-
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
Top 5 Challenges CFOs Face When Implementing CPQ
The automation of business operations currently holds a leading position in the development priorities of many firms. Automation has developed new forms and capabilities since…
Everything You Need To Know About Salesforce Admin Certification Exam
Salesforce is a game-changer, ever-evolving, always innovating, #1 CRM platform globally. It is a huge company growing leap and bounds every year. It welcomes individuals…
What are Pardot Forms? | All You Need to Know
Pardot is a powerful marketing automation tool that can help businesses streamline their lead generation and nurturing processes. One of the key features of Pardot…
Popular Salesforce Videos
Segments of Salesforce Data Cloud
In this extract, Shrey and Vishwajeet break down the different segments of the Salesforce Data Cloud and explain how they can help businesses of all…
Salesforce Guide to Sharing Architecture
The Salesforce sharing model is an essential element in your organization's ability to provide secure application data access. Therefore, it's crucial to architect your sharing…
How to Set Up Web Chat in Salesforce Service Cloud SFDC - Learn Salesforce Series with Algoworks
In this video, you will get to know what the webchat feature in Salesforce Service Cloud is all about. Learn how to - 1. Introduction…
