You need to sign in to do that
Don't have an account?
amarnijer
Display Account Owner on Case
Hi, I want to get Account Owner name from Opportunity.
I have written a soql like below
Select o.Account.Owner.LastName From Opportunity o . then I run it in eclipse.
it is giving a list of blank account.
I want to get it in a single query.
Thanks
All Answers
Select o.AccountId, o.Account.Owner.Name, o.Account.Owner.Employee_Number__c from Opportunity o
Sorry. It is not fromCase. It is from Opportunity.
Thanks @ tech Force, I added Where AccountId != null. but till it is not returning the owner name. do we have any setting upto how many lavel we can quory via chield to parent relationship?
Select o.AccountId, o.Account.Owner.Name, from Opportunity o
Thanks kiran,
It is not dispalying any data.
Please check the link below https://c.ap1.content.force.com/servlet/servlet.ImageServer?id=01590000001KtHI&oid=00D90000000cCSu
Select Account.Name, Account.OwnerId from Opportunity where AccountId != null
You can go into eclipse only upto one level. If you access any of the account field that will be displayed. But you cant see any other relationship data.
You can use execute anonymous block to see this information
Hi Tech Force,
It is giving me the Woner Id, When I type Owner.LastName, it is not giving anything.
https://c.ap1.content.force.com/servlet/servlet.ImageServer?id=01590000001KtIQ&oid=00D90000000cCSu