Connector sorting for timestamp in java does not work

Suite and Optimus Suite 5
#1

Hi,
I have grid which loads data from a connector servlet through render_sql(); One of the field is a time stamp. The sortInfo of that field is set to connector. Whenever i sort the grid based on the time stamp field, the grid does not get sorted appropriately.

#2

When you are using connector sorting, it will result in sql query like

SORT BY myfield

if you need to change that sql sorting command, you can use beforeSort server side events and based on user’s input generate a custom sorting sql.

#3

SORT BY does not exist in the sql’s context. If it is ORDER BY that you are talking about then that does not work either.