On Tuesday, 25 October 2016 01:16:19 UTC+11, Anthony wrote: > > 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 > . >
Hi all, This gets the results using sql but only able to do one or the other is the controller in web2py select * from animalTask order by GREATEST(COALESCE(withhold_until_date,0),COALESCE(esi_withhold_until_date,0)) DESC > > 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.
