-
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
Setting SSO Between Salesforce and Okta’s Salesforce.com Standard Application using SAML 2.0 protocol
SSO(Single Sign On between Okta(Salesforce.com application) as Identity Provider and Salesforce as Service Provider) Steps to setup SSO between Salesforce and Okta’s Salesforce.com Application:- Go…
‘The Killers’, And What’s Not Killing At Salesforce Connections ’18!
Salesforce Connections 2018 is just around the corner and we are as excited as you guys are! “The Killers” are coming to rock the event…
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
How Does SFCC (Headless Commerce) Different From Its Competitors and Why Is It Better? | Salesforce
Let's have look at which one is better SFCC, Shopify, Magento, or Woocommerce. Which one you should choose? Have a glance at this extract from…
Salesforce Org Usage Limits API
This video explains about Salesforce Org Usage Limits API with which we can check the maximum limit and available/remaining limit of a Singe email message,…
Increase ROI by Investing in People | Make Earth Your Business
The video discusses the benefits of businesses that invest in and believe in their employees, customers, and communities. Investing in employee training and upskilling programs…
