Forum Discussion

NAS's avatar
NAS
New Contributor III
2 years ago

SQL query to retrieve base members of a hierarchy

Hi, All Just wanted to share a SQL query I wrote to retrieve base members and parent of a given hierarchy from within a dashboard grid.  (Note that the parameter supplies the member ID of the top m...
Dashboards
Reports
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II

Not sure why my suggestion was rejected, going to try once more:
Adding "ORDER BY Level" to Lines 55 and 111 will sort the parent-child list into an order that is loadable to something that creates a hierarchy.  Clients usually want this order.

sameburn's avatar
sameburn
Contributor II
2 years ago

Thanks RobbSalzmann.  Thanks for input, For my use case I did not want to order by level.  But I can see why you (or a customer) would want to 🙂