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’
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…
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’