How to define an ORDER BY using statementType=AutoSQL on the schema side?

Relativity Server
1

I’ve learned how to manage Dynamic Where, now I’m wondering how can I define an ORDER BY when in the schema the statements are defined as default AutoSQL.
Can someone please give me an hint?

2

Hello,

It isn’t possible to add somehow ‘ORDER BY’ to AutoSQL statement in the Relativity, as you could add WHERE statement using DynamicWhere. In order to get sorted result on the client you could either use DA SQL feature (http://wiki.remobjects.com/wiki/DA_SQL , http://wiki.remobjects.com/wiki/TableRequestInfoV6_Class_(Delphi) ) or get unsorted result and then sort it on the client. Of course you could also change statement type to stSql and add ‘ORDER BY’ statement in it.

Best regards

3

thx! [filler]