Skip to Content
0
Former Member
Sep 06, 2016 at 05:33 PM

Can we (and how) order by date, putting the dates with NULL last, with flexible search ?

178 Views

Can we (and how) order by date, putting the dates with NULL last, with flexible search ?

We want to make with via the FlexibleSearch and to avoid specific database vendor solution, since we work with MySQl for dev machines and Oracle for production and test machine / env

Meaning I would avoid such solutions as:

SELECT {pk} FROM {Address} ORDER BY {address.lastUsed} DESC NULLS LAST

Simply because, this will not work for dev base machines, where MySQL is