Skip to Content (Press Enter)
UserImage.jpg
Carlos Almeida
18Views
2Comments
Order by with nulls first
Question
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
0
0
06 Nov 2015
Copy Link
UserImage.jpg
freek
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.
1
0
06 Nov 2015
Copy Link
UserImage.jpg
Carlos Almeida
Thanks! It worked!
0
0
06 Nov 2015
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.