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 <greg.row...@gmail.com> 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 <mar...@ifi.uio.no> 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
>> 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 <+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
>>
>>
>>
>
>
> --
> *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
