My mistake. I used select(orderby='MAX(arrstart)') where I should have used max() function. It worked for default orderby (ASC) but not DESC. Thank You.
On 22 Jan., 15:27, mdipierro <[email protected]> wrote: > db(...).select(orderby=~db.table.field.max()) > > should translate in "... ORDER BY MAX(table.field) DESC ...". Are you > saying it does not or are you mixing ~ with raw sql? > > On Jan 22, 8:01 am, notabene <[email protected]> wrote: > > > DESC: ORDER BY ~MAX(arrstart) result in a strange sorting! > > ASC: ORDER BY MAX(arrstart) works as expected: > > I can insert DESC in raw sql, but howto specify in db.select? > > > SELECT arrdato.arrid, MAX(arrstart), COUNT(arrid) FROM arrdato WHERE > > ((arrdato.stedid=1 OR arrdato.arrangid=1) AND > > arrdato.arrstart<'2009-01-22 14:16:48') GROUP BY arrdato.arrid ORDER > > BY ~MAX(arrstart) LIMIT 10 OFFSET 0; > > > Result > > [(3, u'2009-01-20 14:53:46', 1), (4, u'2009-01-14 16:56:11', 1), (5, > > u'2009-01-11 16:58:00', 1), (12, u'2009-01-20 13:08:00', 1), (15, > > u'2009-01-22 13:16:00', 1), (16, u'2009-01-20 13:34:00', 1), (1, > > u'2008-12-31 15:08:41', 1)] > > > 3 2009-01-20 14:53:46 > > 4 2009-01-14 16:56:11 > > 5 2009-01-11 16:58:00 > > 12 2009-01-20 13:08:00 > > 15 2009-01-22 13:16:00 > > 16 2009-01-20 13:34:00 > > 1 2008-12-31 15:08:41 > > > SELECT arrdato.arrid, MAX(arrstart), COUNT(arrid) FROM arrdato WHERE > > ((arrdato.stedid=1 OR arrdato.arrangid=1) AND > > arrdato.arrstart<'2009-01-22 14:46:06') GROUP BY arrdato.arrid ORDER > > BY MAX(arrstart) LIMIT 10 OFFSET 0; > > > Result > > [(1, u'2008-12-31 15:08:41', 1), (5, u'2009-01-11 16:58:00', 1), (4, > > u'2009-01-14 16:56:11', 1), (12, u'2009-01-20 13:08:00', 1), (16, > > u'2009-01-20 13:34:00', 1), (3, u'2009-01-20 14:53:46', 1), (15, > > u'2009-01-22 13:16:00', 1)] > > > 1 2008-12-31 15:08:41 > > 5 2009-01-11 16:58:00 > > 4 2009-01-14 16:56:11 > > 12 2009-01-20 13:08:00 > > 16 2009-01-20 13:34:00 > > 3 2009-01-20 14:53:46 > > 15 2009-01-22 13:16:00 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
