You need to sign in to do that
Don't have an account?

Getting Account Owner Name from Opportunity
Hi All,
I don't think this is possible, but before I gave up and just ran two queries, I wanted to check with you smart folks. I am trying to get the Account Owner Name and Employee number from an opportunity query. I know I can get to the Account.OwnerId but that is as far as it goes without writing another query to the User object for the name and employee number.
Here is my query:
Select o.Id, o.Account.Business_Unit__c, o.Account.Sub_Status__c, o.Account.Official_Name__c,
o.Account.Status__c, o.Account.Client_ID__c, o.Account.OwnerId, o.Account.Industry, o.Account.Website,
o.Account.BillingCountry, o.Account.BillingPostalCode, o.Account.BillingState, o.Account.BillingCity,
o.Account.BillingStreet, o.Account.Id, o.AccountId From Opportunity o
Where o.StageName >= '6 - Closed/Won'
I also need to return the Account Owner Name and Employee number but I have come up empty thus far except writing another query to the User object where User.Id = o.Account.OwnerId.
Any thoughts or suggestions will be greatly appreciated.
Thanks,
Steve
Easy enough, you can just do something like this:
Select o.AccountId, o.Account.Owner.Name, o.Account.Owner.Employee_Number__c from Opportunity o
You can go as many as 5 parents high in a single query.