dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #38359
Re: Analytics API: ORDER BY [CASE]
Sorry Devs, i can tell that the API uses the sequence in which UID values
appear in [_orgunitstructure].[uidlevelX].
New Question: Is it possible to load table [_orgunitstructure].uidlevelX
fields according to organisationunit.name sequence? At the moment this
sequence seems to be unplanned...
On Fri, Jul 3, 2015 at 1:43 PM, Greg Rowles <greg.rowles@xxxxxxxxx> wrote:
> Hi Devs
>
> I'm trying to figure out how the API manages the output sequence of data
> values.
>
> I can tell that it must use ORDER BY [CASE] for dx values (according to
> the querystring sequence) but there is no obvious sequencing of ou values.
> Without understanding the underlying components - is it possible to request
> some sort of logical sequencing for orgunits? e.g. ORDER BY [CASE]
> 'displayProperty'
>
> Kind Regards,
> Greg
>
> --
> *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
References