Order by with nulls first

Order by with nulls first

Hey everyone.

I'm running Outsystems in a Java/Oracle environment. I need to order some data by Date Desc, but I need to show the null dates first. The data is already being retrieved in an aggregate, so If there is a way to do this with an aggregate it would make thinks easier.

I tried a dinamic order by using Oracle's "Null First" order by option, but the platform didn't really like it.

Thanks everyone for you help!

Carlos Almeida
Hi Carlos,

I did this once by creating a second attribute with the statement: if nulldate then currdate+100 years then do a order by desc where the nulldates will be first.
Thanks! It worked!