-
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
All New Salesforce Sales Cloud to Help You Progress in a Digital-First World
Work in the sales and marketing landscape has altered drastically. And the truth is that not all sales software solutions can keep up with the…
Visualforce Basics | Salesforce Learning Guide
Visualforce is a powerful tool and a stimulating framework allowing developers to explain the interface component and to create sophisticated custom interfaces which will be…
Definition and Benefits of Salesforce Marketing Cloud
Salesforce is a leading provider of cloud-based software solutions for sales, marketing, and customer service. Salesforce Marketing Cloud is a comprehensive platform that allows businesses…
Popular Salesforce Videos
Why Salesforce is a Good Entrepreneurial Opportunity for Veterans
Are you a military veteran or military spouse? Have you dreamed of having your own business? This video is for you! This video covers an…
How to Integrate Commerce, Marketing and Service Using Salesforce Customer 360
Developers, Integrators, Admins and Architects all work together to deliver projects that span multiple Salesforce products. Salesforce is making it simpler by providing native integration…
Quick Text in Salesforce | Service Cloud | Salesforce Tutorial
In this video, we will talk about what is Quick text and how to implement those Quick texts inside Salesforce. Watch the video and let…
