-
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
Insert Record using JavaScript Remoting with Visualforce Page
Hey there! We must have heard about javascript remoting. So today we are going to learn about how to use the Javascript remoting to build…
Why Your Business Needs Salesforce Consulting Now More Than Ever?
As the business world rapidly evolves, companies are facing unprecedented challenges in staying competitive and relevant. One of the most effective ways to gain an…
Salesforce for Manufacturing to Optimize Productivity
The manufacturing sector has witnessed a complete, factory-wide digital makeover. The industries have leveraged technologies like artificial intelligence (AI), robotics, and blockchain. Salesforce for manufacturing…
Popular Salesforce Videos
How to Find Job as a Fresher in Salesforce - Tips and Tricks
In this video Rohit Puri gives a detailed explanation of the questions that everyone has regarding Salesforce jobs, how to find jobs in Salesforce on…
How To Use RingCentral App In Salesforce | Salesforce Service Cloud
Learn how to use RingCentral App in Salesforce. This video will cover the following points - 1. Advantages Take a look at the advantages of…
Salesforce Marketing Cloud Connect: Subscriber Key Migration
We demo how leveraging a subscriber key migration to remove duplicate subscribers from Sales or Service Cloud in Marketing Cloud while minimizing data loss. Explore…
