On Monday, October 24, 2016 at 7:11:29 AM UTC-4, Anthony Smith wrote: > > Hi all, > > I have table with 2 fields, withhold _until_date and esi_withhold_until. > > Is is it possible to order by so the the greater of the 2 fields was at > the top of the list. >
I think there are various ways to achieve this in SQL, though not sure you could easily use the DAL to generate that SQL. Does you query involve a limitby or pagination (i.e., does the sorting have to be done by the database as part of the query)? If not, you could instead do the sorting in Python -- check out the Rows.sort method: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#find--exclude--sort. Anthony -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
