-
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
Integration from Quickbook Desktop to Salesforce Using DBSync
Hello guys, Today, I am going to show you integration from Quickbook Desktop to Salesforce Using DBSync Requirement:- Salesforce Account Quickbook Desktop must be installed.…
Zendesk and Salesforce Connector - Hassle-free Data Migration from Zendesk to Salesforce
From small businesses to large organizations, data migration is a challenge. Also, keeping the data secure during different phases of the migration process has been…
Fast Track your Marketing Activities and Enhance User Experience with DemandBlue's Salesforce Marketing Cloud Accelerators
Salesforce Marketing Cloud is one of the most used digital marketing platforms. DemandBlue’s set of Marketing Cloud and Pardot accelerators are uniquely backed by a decade of…
Popular Salesforce Videos
How To Land A Salesforce Job In India
This video explained about to land a Salesforce job in India. This is a great opportunity to enter the Salesforce echo systems for non-Salesforce professionals…
Salesforce Tutorial for Beginners: Profiles and Permission Set in Salesforce
Modules Covered in this Training 1. Configuration Custom objects in salesforce Standard Objects in salesforce Lookup, Master Detail and Many to Many relationship in salesforce…
Service Work Order with Salesforce CRM Cases
In this video, Steve Campisi explains how the Service Work Order works with Salesforce CRM Cases. Watch this video and learn all about Service Work…
