dhis2-users team mailing list archive

["Friedman, Roger (CDC/OID/NCHHSTP) (CTR)" <rdf4@xxxxxxx>]

Folks --

            I note you are using two tables to help you navigate through
the org tree.  Here is an SQL-friendly way of representing trees I
learned some years ago from Joe Celko.  I think this might make the
aggregation task a lot simpler.

Regards, Roger

Attachment: treesql.png
Description: treesql.png