dhis2-devs team mailing list archive

[Greg Rowles <greg.rowles@xxxxxxxxx>]

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