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 PickeringDate: Thu, 19 Mar 2015
07:10To: [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 PolakDate: Wed, 18 Mar 2015 22:44To:
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 [email protected][email protected]+47 970 36 752
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 3130Fax: 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
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
