-
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
Fuel Your B2B Marketing Engine With Salesforce Marketing Cloud
Are you considering implementing a top-notch marketing automation platform? Sure, it takes your marketing operations to the next level. But as you start your research, you…
Salesforce for Energy and Utility Sector for Adapting to New Customer Expectations
Energy and utility companies are known to have contingency plans to remain stable in any uncertain situation. And that’s where digitization has helped such companies…
Getting Started with Salesforce: Quick Wins to See Fast Results | Greytrix
Is Salesforce implementation something you're thinking about for your business? You've arrived to the perfect post, then! Implementing Salesforce correctly is another step that many…
Popular Salesforce Videos
What is Salesforce? What Does it Do?
Business is rapidly changing. In this digital age, everything and everyone is connected, which is changing the way we communicate with our consumers. Businesses nowadays…
Write Tableau CRM Data to Salesforce Objects
Leverage the power of fully native analytics in your CRM workflows with Tableau CRM. Salesforce CRM users can work more efficiently, spot trends, predict outcomes,…
Mocking Apex Tests: Salesforce Tutorial
In this Video Leonardo Berardino talks about the following: Mocking Apex Tests and Apex Mock Examples Unit Tests x Integration Tests How to create unit…
