Order By Date and Nulls

Posts   
 
    
Anthony
User
Posts: 155
Joined: 04-Oct-2006
# Posted on: 28-Sep-2013 04:46:15   

llblgen v3, adapter,vb.net

Want to sort by date asc but do not NULLS to be on the top

How do i do this in llblgen

ORDER BY (CASE WHEN [Submission Date] IS NULL THEN 1 ELSE 0 END) DESC, [Submission Date] DESC

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 28-Sep-2013 05:30:19   
Anthony
User
Posts: 155
Joined: 04-Oct-2006
# Posted on: 28-Sep-2013 05:50:13   

Any suggestion on how i put this expression into llblgen?

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 28-Sep-2013 08:20:42   
    IExpression datePart = new DbFunctionCall("CASE WHEN {0} IS NULL THEN 1 ELSE 0 END", new object[] { OrdersFields.OrderDate });
    IEntityField2 datePartField = OrdersFields.OrderDate.SetExpression(datePart);

    // prepare the sorter
    ISortClause datePartSortClause = new SortClause(datePartField, null, SortOperator.Descending);
    datePartSortClause.EmitAliasForExpressionAggregateField = true;
    ISortExpression sorter = new SortExpression(datePartSortClause);
    sorter.Add(OrdersFields.OrderDate | SortOperator.Descending);