You need to sign in to do that
Don't have an account?
cw.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.
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