-
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
10 Ways to Improve Report Performance - Salesforce Developer Guide
Do your massive reports take a long time to return data? Here are several tried and tested ways that you'll be able to maximize report…
What are Validation Rules in Salesforce in 2023?
In this blog, we will explore the importance of validation rules and how to create them in Salesforce. What are Validation Rules in Salesforce? Validation…
Safer Data Migration With Salesforce Audit Fields
In the last decade, companies have made a huge switch from legacy, on-premise servers to cloud-based applications. This shift has had lots of benefits — increased flexibility,…
Popular Salesforce Videos
Salesforce DMP – Capture, Unify and Activate Your Data
Learn how the Salesforce DMP allows marketers to capture, unify and activate their data enabling them to deliver more relevant and personalized experiences to their…
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…
Permissions In Salesforce Experience Cloud Explained | Salesforce Communities
A permission set is a collection of settings and permissions that give users access to various tools and functions. Permission sets extend users' functional access…
