dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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