Yes exactly, but we’re not sure if he’s building an app, or importing it somewhere. But non the less i agree that should be easy enough to do.
Kind regards, Mark Polak m...@thedutchies.com mar...@ifi.uio.no +47 970 36 752 On 19 Mar 2015, at 10:51, Jason Pickering <jason.p.picker...@gmail.com> wrote: > 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 >>>> >>>> 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