I’m reconstructing the JSON output called by the analytics API to (hopefully) give me the parent hierarchy structure in individual “columns”. This ties in with my previous email about SHORTNAME outputting long NAME values for the ouNameHierarchy collection. I’m trying to split ouNameHierarchy into its different parent values for use in a custom report.
Hi Greg,
Have you considered (if it is possible for you) to use an SQL view for this? Sounds like it would be rather trivial to generate this view from the _orgunitstructure table by joining with the organisationunit table. May not be feasible in this case, but might save a bit of trouble on the client side.
I’m reconstructing the JSON output called by the analytics API to (hopefully) give me the parent hierarchy structure in individual “columns”. This ties in with my previous email about SHORTNAME outputting long NAME values for the ouNameHierarchy collection. I’m trying to split ouNameHierarchy into its different parent values for use in a custom report.
Is it possible to have the organisationUnitLevels stack outputted in the sequence the hierarchy is arranged? E.g. it appears to be sorted by name value with ‘National’ always appearing down the list (it should be 1st)…
Best,
Greg
– Health Information Systems Program - South Africa