Put Null Values at end of the colunma
Question

Hey , 

I am trying to order a column  i always want, independently it is ASC or DESC , the null/nullidentifier() values at the end of the column . My column is datatype Text. 

Some Idea there, in aggregates or Sql but that works in Outsystems?

Regards

mvp_badge
MVP

Hi.

You can create a calculated column to turn the value Null/NotNull into binary code.

Order by that one first, and then by a dynamic criteria on the real value

.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.