db(....).select(orderby="sort_expression1 ASC NULLS LAST")
orderby can be a string in SQL.
# from gluon.dal import Expression was a cut and paste error
On Monday, 17 September 2018 21:40:53 UTC-7, Massimo Di Pierro wrote:
>
> 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.
