from gluon.dal import Expression
db(....).select(orderby="sort_expression1 ASC NULLS LAST")
orderby can be a string in SQL.
On Monday, 10 September 2018 01:10:08 UTC-7, Mike Constabel wrote:
>
> Hello,
>
> is it possible to sort NULLS last with orderby desc?
>
> orderby=~db.table.last_login
>
> I want the empty last_login last in desc sorting.
>
> On postgresql:
>
> ORDER BY sort_expression1 [ASC | DESC] [NULLS { FIRST | LAST }]
>
>
> Thanks,
> Mike
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
