Nice! Thanks everyone, sorry for taking so long to respond - this conversation was somehow marked as read ...
On Thu, Mar 19, 2015 at 2:02 PM, Jan Henrik Øverland < [email protected]> wrote: > Or: > https://apps.dhis2.org/demo/api/organisationUnitLevels.json?fields=id,name,level&paging=false > > On Thu, Mar 19, 2015 at 12:45 PM, Greg Rowles <[email protected]> > wrote: > >> Not sure if this will become an app or not, too early to tell. I think >> Jason's json URL will definitely work! Thanks guys! >> >> On Thu, Mar 19, 2015 at 11:52 AM, Mark Polak <[email protected]> wrote: >> >>> 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 >>> [email protected] >>> [email protected] >>> +47 970 36 752 >>> >>> On 19 Mar 2015, at 10:51, Jason Pickering <[email protected]> >>> 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 <[email protected]> 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 >>>> [email protected] >>>> [email protected] >>>> +47 970 36 752 >>>> >>>> On 19 Mar 2015, at 10:47, Jason Pickering <[email protected]> >>>> 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 <[email protected]> >>>> 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 <[email protected]> >>>>> wrote: >>>>> >>>>>> If you are indeed building your own app, you can also sort the levels >>>>>> on the client :) >>>>>> >>>>>> Kind regards, >>>>>> >>>>>> Mark Polak >>>>>> [email protected] >>>>>> [email protected] >>>>>> +47 970 36 752 >>>>>> >>>>>> On 19 Mar 2015, at 08:47, Abyot Gizaw <[email protected]> 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" <[email protected]> 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 <[email protected]> >>>>>>> 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 >>>>>>>> [email protected] >>>>>>>> [email protected] >>>>>>>> +47 970 36 752 >>>>>>>> >>>>>>>> On 19 Mar 2015, at 07:49, Greg Rowles <[email protected]> >>>>>>>> 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 < >>>>>>>> [email protected]> 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, [email protected] < >>>>>>>>> [email protected]> 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: *[email protected]; >>>>>>>>>> *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, [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 >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Jason P. Pickering >>>>>>>>> email: [email protected] >>>>>>>>> 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 : [email protected] >>>>>>> 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 : [email protected] >>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>>> >>>> -- >>>> Jason P. Pickering >>>> email: [email protected] >>>> tel:+46764147049 >>>> >>>> >>>> >>> >>> >>> -- >>> Jason P. Pickering >>> email: [email protected] >>> 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 : [email protected] >> 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
