Hierarchial SOQL Query

salesforce soql oql
karthick picture karthick · Mar 31, 2011 · Viewed 7.6k times · Source

Does anyone know how to retrieve the hierarchical model of a account based on it's id?

I tried using this query but all i got is the first set of child nodes.

select a.Name,a.parentId,a.ownerid,a.id from  Account a where Parent.id ='00711314'

Answer

mmix picture mmix · Apr 1, 2011

SOQL does not support hierarchical retrieval, you have to retrieve level by level, for each level generate a list of id's and then retrieve next level using in <list> where operator.

Keep in mind though that governor limitations apply and if you have large trees you'll run into a limit quite easily.

Related questions

SOQL query WHERE Date = 30_days_ago?

How do I make a SOQL query like this? SELECT id FROM Account WHERE LastActivityDate = 30_DAYS_AGO This produces an error: MALFORMED_QUERY: Account WHERE LastActivityDate = 30_DAYS_AGO ^

Read More
SOQL query with subquery

I'm having trouble getting the results I want from a Salesforce/Apex/SOQL query. I want: A list of Contact objects containing only contacts who are CampaignMembers of a set of campaigns; and they should have the data from that …

Read More
salesforce SOQL : query to fetch all the fields on the entity

I was going through the SOQL documentation , but couldn't find query to fetch all the field data of an entity say , Account , like select * from Account [ SQL syntax ] Is there a syntax like the above in SOQL to fetch all …

Read More