+ Start a Discussion

SOQL query in developer console

Simple Child to parent query in developer console returns as [object object] .
SOQL query :
SELECT Account.Owner.Name FROM Contact

any suggestions please.

Hi Desai,

you can use workbench to see the right result.
go through this link for work around https://developer.salesforce.com/forums/?id=9060G000000BfMjQAK

Ajay K DubediAjay K Dubedi
Hi Desai,

Yes, you are right that this query 'SELECT Account.Owner.Name FROM Contact' returns data in the form of  [object object] when we execute in Query editor, but if we run this query in the Execute Anonymous window it returns a list.
I believe this is currently a limitation or bug of the dev console. Trying to flatten a javascript object to a string returns the literal "[object Object]" you're seeing here, but would work for non-cross-object fields.
In the meantime the query is perfectly valid and if you run anonymous apex like:
List<Contact> conList=[SELECT Account.Owner.Name FROM Contact];

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Ajay Dubedi