← Back to team overview

dhis2-devs team mailing list archive

Re: api/organisationUnitLevels

 

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 <markpo@xxxxxxxxxx> 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
> mark@xxxxxxxxxxxxxxx
> markpo@xxxxxxxxxx
> +47 970 36 752
>
> On 19 Mar 2015, at 10:51, Jason Pickering <jason.p.pickering@xxxxxxxxx>
> 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 <markpo@xxxxxxxxxx> 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
>> mark@xxxxxxxxxxxxxxx
>> markpo@xxxxxxxxxx
>> +47 970 36 752
>>
>> On 19 Mar 2015, at 10:47, Jason Pickering <jason.p.pickering@xxxxxxxxx>
>> 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.rowles@xxxxxxxxx>
>> 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 <markpo@xxxxxxxxxx> wrote:
>>>
>>>> If you are indeed building your own app, you can also sort the levels
>>>> on the client :)
>>>>
>>>> Kind regards,
>>>>
>>>> Mark Polak
>>>> mark@xxxxxxxxxxxxxxx
>>>> markpo@xxxxxxxxxx
>>>> +47 970 36 752
>>>>
>>>> On 19 Mar 2015, at 08:47, Abyot Gizaw <abyota@xxxxxxxxx> 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.rowles@xxxxxxxxx> 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 <markpo@xxxxxxxxxx> 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
>>>>>> mark@xxxxxxxxxxxxxxx
>>>>>> markpo@xxxxxxxxxx
>>>>>> +47 970 36 752
>>>>>>
>>>>>> On 19 Mar 2015, at 07:49, Greg Rowles <greg.rowles@xxxxxxxxx> 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.pickering@xxxxxxxxx> 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.rowles@xxxxxxxxx <
>>>>>>> greg.rowles@xxxxxxxxx> 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.rowles@xxxxxxxxx;
>>>>>>>> *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.rowles@xxxxxxxxx <
>>>>>>>> greg.rowles@xxxxxxxxx> 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
>>>>>>>>> mark@xxxxxxxxxxxxxxx
>>>>>>>>> markpo@xxxxxxxxxx
>>>>>>>>> +47 970 36 752 <+47%20970%2036%20752>
>>>>>>>>>
>>>>>>>>> On 18 Mar 2015, at 21:26, Greg Rowles <greg.rowles@xxxxxxxxx>
>>>>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Jason P. Pickering
>>>>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>>>>> tel:+46764147049
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Jason P. Pickering
>>>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049
>>
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>
>
>


-- 
*Health Information Systems Program - South Africa*
*- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - *
Mobile  :    073 246 2992
Landline:   021 554 3130
Fax:          086 733 8432
Skype:      gregory_rowles

Follow ups

References