dhis2-devs team mailing list archive

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

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