-
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
Dreamforce 2024: How It Will Affect Your Business Plan and Strategies?
Are you ready to change the way you do business? Revolutionary upgrades that will change the way you use Salesforce for growth are expected to…
4 Steps to Successful Salesforce Data-Integration
Data integration is a process to streamline data from various sources into a single, unified view. The ultimate goal here is to pave a path…
Revolutionizing Customer Connections with the Salesforce Messaging Platform
In the vast landscape of digital business, where every interaction counts, the Salesforce messaging platform emerges as a beacon of innovation. It's not just about…
Popular Salesforce Videos
What is the Difference Between Object and Database in Salesforce?
Salesforce Object: Salesforce Object are database table which give permission to store data that is specific to organization. Salesforce Database: The organized collection of object…
The History of Salesforce
Well, it's about time to talk about the history of the company that became a $10 Billion Dollar Industry from an efficient CRM. Watch this…
Getting Information from your Salesforce Account for a Salesforce Connection
Watch this video to learn how to get information from your Salesforce Account for a Salesforce Connection. Do let us know in the comment section…
