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.
Regards, Jason On Thu, Mar 19, 2015 at 6:06 AM, [email protected] < [email protected]> wrote: > Hi Mark > > > 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. > > > Regards, > > Greg > > > > ------ Original message------ > > *From: *Mark Polak > > *Date: *Wed, 18 Mar 2015 22:44 > > *To: *Greg Rowles; > > *Cc: *DHIS 2 developers; > > *Subject:*Re: [Dhis2-devs] api/organisationUnitLevels > > > Hey Greg, > > Unfortunately i don’t think sorting through the api is available “yet”. > > What are you using it for? > > Kind regards, > > Mark Polak > [email protected] > [email protected] > +47 970 36 752 <+47%20970%2036%20752> > > On 18 Mar 2015, at 21:26, Greg Rowles <[email protected]> wrote: > > Hi Devs > > 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* > *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - > - * > Mobile : 073 246 2992 > Landline: 021 554 3130 > Fax: 086 733 8432 > Skype: gregory_rowles > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
