-
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
What is an Enhanced Domain in Salesforce in 2023?
Enhanced domains are coming to My Domain in a future version. All URLs within your company—including those for your Experience Cloud sites, Salesforce Sites, Visualforce…
Automation Hero | Salesforce Process Builder a step ahead Workflow
Every day at our workplace, we spend a considerable amount of time doing routine work processes that mostly repetitive and do not require any special…
3 Top Challenges with Data Migration to Salesforce you Want to Avoid
Moving data to a new system, especially Salesforce, can be a daunting task. In this blog post, we'll delve into three issues that commonly arise…
Popular Salesforce Videos
Introduction to Salesforce OmniStudio | Salesforce Industries
Introduction to Salesforce OmniStudio: The Salesforce OmniStudio digital engagement suite makes it easy to click-configure rich, consumer-grade user experiences based on objects, APEX classes, REST…
3 Must-Have Validation Rules in Salesforce to Save Time and Avoid Costly Mistakes
Validation rules in Salesforce act like quality checks for your data. They help make sure that the data in your Salesforce org is accurate and…
Dynamic Report Charts & Customer 360 View in Salesforce - Learn Salesforce Series By Algoworks
In this video, the following points will be covered - 1. Introduction Introduction to conventional setup for Customer 360. 2. Prerequisites Setting up a base…
