Can somebody help:
SELECT LastModifiedDate, Quantity, TotalPrice, Opportunity.AccountId, Opportunity.Billing_Country__c, Opportunity.CloseDate, Opportunity.End_User__r.name, Opportunity.LastActivityDate, Opportunity.Opportunity_reference__c, Opportunity.Probability, Product2.Family, Product2.Name FROM OpportunityLineItem
2 respostas
Hi Jonathan - by enduser, are you refering to the owner? if so this is the query (add any account and user fields as you require):
select name, account.owner.name from account
as you can see you can traverse the lookup to user by using account.<lookup name>.<field on target object>
