-
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
Learn About Query Languages & DML in Salesforce
To fetch data, we have a query language in Salesforce. Below are the database query languages in Salesforce. SOQL - Salesforce object query language SOSL…
A Detailed Guide to Salesforce RPA Integration in 2023
Salesforce is one of the most popular CRM software in the world. There are a lot of benefits to using Salesforce, but one of the…
Top 5 Use Cases of Salesforce Partner Portal
Struggling to work together with external partners on projects? A Salesforce partner portal is your solution! These portals act as a central hub for your…
Popular Salesforce Videos
Creating A Chart in Einstein Analytics
In this video, you will learn how to create a new dashboard, and add a chart. You will also learn how to select the dataset…
Dreamforce 2019 - An Overview!
Salesforce Dreamforce2019 is scheduled for November 19-22 in San Francisco, California at the Moscone Center. #Dreamforce is one of the largest cloud and SaaS-centric conferences…
Salesforce Careers - Why Consider A Career In Salesforce
This Salesforce Training Video will help you understand about Salesforce, Salesforce market situation, Salesforce job trends, Salesforce career options and how Salesforce is a safe…
