Hi Greg, Yeah, I can understand that. Jan can probably provide more detail here, but for instance
[1]https://apps.dhis2.org/demo/api/organisationUnitLevels/ gives you all levels [2]https://apps.dhis2.org/demo/api/organisationUnitLevels/H1KlN4QIauv gives you the number of the level, in this case 1. You could do this for each level. [3]https://apps.dhis2.org/demo/api/organisationUnits?filter=level:eq:1 Gives all units at a given level, or https://apps.dhis2.org/demo/api/organisationUnits?fields=id,level,name,parent[id]&paging=false which would give you a list which you could then recursively parse to get what you need I think. Regards, Jason On Thu, Mar 19, 2015 at 6:34 AM, greg.row...@gmail.com < greg.row...@gmail.com> wrote: > Hi Jason > > > Yes, we've considered that but we want to avoid depending on SQlviews for > everything (too many variations need to be built to cater for different > OUlevels) which becomes something of a db mgmt concern. I will try a > different method of looking up OUlevels - that sequence issue would have > made things really simple though. > > > In DHIS 1.4 we associated a level number with a level name. I see this was > not implemented in DHIS2... Does anyone know why not? > > > Regards, > > Greg > > > ------ Original message------ > > *From: *Jason Pickering > > *Date: *Thu, 19 Mar 2015 07:10 > > *To: *greg.row...@gmail.com; > > *Cc: *Mark Polak;DHIS 2 developers; > > *Subject:*Re: [Dhis2-devs] api/organisationUnitLevels > > > 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, greg.row...@gmail.com < > greg.row...@gmail.com> 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 >> m...@thedutchies.com >> mar...@ifi.uio.no >> +47 970 36 752 <+47%20970%2036%20752> >> >> On 18 Mar 2015, at 21:26, Greg Rowles <greg.row...@gmail.com> 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 : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp