You need to sign in to do that
Don't have an account?
nabil711
SOQL: query for lookup relationship
Hi
in QuoteLineItem, I have a field Produit
name : Product2 & Type : lookup(Produit)
I need a SOQL query to get information (Family & Name) from Object Product2
Select Product2.Name From QuoteLineItem
doesn't work
I tried a lot of queries same problems
Thanks
Try below query.
"Select ID,Pricebookentry.Product2.Name,Pricebookentry.Product2.Family from QuoteLineItem"
Regards,
Kamlesh Chauhan
LogicRain Technologies
All Answers
Hi,
See this,
here AZ belongs to analyze object and having one field doctor name as look up to contact and selecting mailing address from contact.
AZ =[select id,name,Doctor_Name__r.MailingStreet from analyze];.
Hope this will helps u.
Regards,
Rajesh.
Try below query.
"Select ID,Pricebookentry.Product2.Name,Pricebookentry.Product2.Family from QuoteLineItem"
Regards,
Kamlesh Chauhan
LogicRain Technologies
Finally it works Thanks a lot :)