Thanks Jason, I'll do some testing. I know offhand of a viewClass parameter but it may not be applicable to this object, will see...
Best, Greg On Thu, Mar 19, 2015 at 7:46 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > 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 > -- *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