function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
cw.ax43cw.ax43 

Retrieving Account hierarchy

Hi,

I'm expecting the answer to be "no", but is there any easy way to get all the Accounts in the hierarchy that an Account belongs to?  I'm trying to avoid doing the brute force approach of retrieving the Account and then making successive queries to retrieve other Accounts that are related to it up, down, and sideways in the tree -- This is quite inefficient.

 

 

Michael SMichael S

This is what we've done:

Do a single query which gets the account IDs and their parentsIDs.  Then use XSLT to transform the list into a hierarchy.  You will still need to do an another query for each account in the hierarchy.  We are working on a solution for displaying this hiearchy in a map form using MindManager X5 Pro.  Please contact me if you are interested in exploring this type of solution.

Michael S. Scherotter
michaels@mindjet.com
Business Solutions Architect
http://www.mindjet.com