OK, but but the "level" attribute is numeric, and seems it could easily be sorted by the client?
{"created":"2015-03-19T09:46:38.286+0000","organisationUnitLevels":[{"name":"District","created":"2011-12-24T11:24:22.935+0000","lastUpdated":"2014-04-29T18:23:38.202+0000","externalAccess":false, "level":2, "id":"wjP19dkFeIk"},{"name":"Chiefdom","created":"2011-12-24T11:24:22.935+0000","lastUpdated":"2014-04-29T18:23:38.209+0000","externalAccess":false, "level":3, "id":"tTUf91fCytl"},{"name":"National","created":"2011-12-24T11:24:22.935+0000","lastUpdated":"2014-04-29T18:23:38.212+0000","externalAccess":false, "level":1, "id":"H1KlN4QIauv"},{"name":"Facility","created":"2011-12-24T11:24:22.935+0000","lastUpdated":"2014-04-29T18:23:38.215+0000","externalAccess":false," level":4,"id":"m9lBJogzE95"}]} On Thu, Mar 19, 2015 at 10:49 AM, Mark Polak <mar...@ifi.uio.no> wrote: > It does return the orgunit levels, but Greg’s initial request was to > return them ordered by level instead of name. :) > > Kind regards, > > Mark Polak > m...@thedutchies.com > mar...@ifi.uio.no > +47 970 36 752 > > On 19 Mar 2015, at 10:47, Jason Pickering <jason.p.picker...@gmail.com> > wrote: > > Does this not provide what you need? > > > https://apps.dhis2.org/demo/api/metaData.json?assumeTrue=false&organisationUnitLevels=true > > Regards, > Jason > > > > On Thu, Mar 19, 2015 at 9:27 AM, Greg Rowles <greg.row...@gmail.com> > wrote: > >> Is there any chance we could get organisationUnitLevels data added into >> the [metaData] branch of the JSON output? >> >> On Thu, Mar 19, 2015 at 10:10 AM, Mark Polak <mar...@ifi.uio.no> wrote: >> >>> If you are indeed building your own app, you can also sort the levels on >>> the client :) >>> >>> Kind regards, >>> >>> Mark Polak >>> m...@thedutchies.com >>> mar...@ifi.uio.no >>> +47 970 36 752 >>> >>> On 19 Mar 2015, at 08:47, Abyot Gizaw <aby...@gmail.com> wrote: >>> >>> Seems you are creating your own app? If so, you can fetch OUs based on >>> level whenever drill down/up is triggered >>> >>> ----- >>> Thank you, >>> Abyot. >>> >>> (sent from mobile) >>> On Mar 19, 2015 8:14 AM, "Greg Rowles" <greg.row...@gmail.com> wrote: >>> >>>> Hi Mark >>>> >>>> My JSON request: >>>> >>>> api/analytics.json?dimension=pe:LAST_3_MONTHS&dimension=dx:trqWVUf9e6D;lPVvmrINVHS;eDktBD88IUL&dimension=ou:LEVEL-3;JLA7wl59oN3&hierarchyMeta=true&displayProperty=NAME&showHierarchy=true >>>> >>>> The objective is to reconstruct JSON to include columns for all >>>> parent-orgunits. >>>> >>>> Some background to this - we have several reports specified in 'pivot >>>> table' layout but we need to make these outputs drill-through. Reporting is >>>> expected down to facility level for the last 3 months for the entire >>>> country - I assume this amount of data would probably choke the browser so >>>> I'm wanting to create a dynamic HTML report with drill-through capabilities >>>> but starting at regional levels. The current 'show hierarchy' functionality >>>> in pivot tables is insufficient plus it does not support drill-through >>>> 'mining'. I was planning on using PivotTable.js to accomplish this... >>>> >>>> >>>> >>>> On Thu, Mar 19, 2015 at 8:56 AM, Mark Polak <mar...@ifi.uio.no> wrote: >>>> >>>>> If you’re getting the data in JSON format. And you’re using it to >>>>> reconstruct something, how are you retrieving this data? Otherwise it >>>>> would >>>>> be trivial to sort it on your side? >>>>> >>>>> Kind regards, >>>>> >>>>> Mark Polak >>>>> m...@thedutchies.com >>>>> mar...@ifi.uio.no >>>>> +47 970 36 752 >>>>> >>>>> On 19 Mar 2015, at 07:49, Greg Rowles <greg.row...@gmail.com> wrote: >>>>> >>>>> 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 >>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> *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 >>>> >>>> >>> >> >> >> -- >> *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 >> >> > > > -- > 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