Dynamic ORDER BY

Data Abstract
1

does DA supports dynamic order by clause (like where)?

2

Hi,

not yet.

you can’t pass dynamic order by clause (like where) from client-side.
on server-side, you can create AutoSQL sql statement with dynamic order by

3

ok and how could i ‘tell’ the server when and which dynamic order by to use?

(i want to get rid of our own getdata calls for these kind of things)

4

Hi,

we have no universal solution yet.

you can create own descendant of TableRequestInfo where you can include OrderBy
on server-side you can override GetData method

another workaround: use the DASQL feature.

5

DASQL only supported on .net?

6

Hi,

The DA SQL feature is supported on Delphi since May 2020.
see more at https://talk.remobjects.com/t/data-abstract-for-delphi-vnext-new-features/19700/6

7

Not a workarund. everybody should be using this, really.