Hi there,

I wish to sort an entity collection by a date column, descending, but with null values at the top. What is the easiest way to achieve this? In SQL I'd use a case statement in my ORDER BY clause.

I am using the adapter model with LLBLGen Pro 2.5.

Thanks for your time.

Cheers, Andrew

2.5 supports case statements. so you should be able to create a custom EntityField2 using the case statement as a expression of the field. then add this to the sortexpression object.

another alternative. filter the null entities into a entity collection. filter the non-null entities into another collection. then add the non-nulls to the null collection.

Cool, thanks!