Thanks a lot Massimo and mcamel, its working as expected :) Regards, Amit On Sat, Aug 18, 2012 at 7:04 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote:
> My bad. It should be > > t.created_on.max() > > > On Saturday, 18 August 2012 04:26:37 UTC-5, mcamel wrote: >> >> Hi, >> >> Massimo, i really like your framework. Thank you very much for your >> dedication. >> >> I'm newbie and don't want to bother but... i think some details are >> missing in the manual so that we can build this kind of selects by our own, >> or even understand the query below. >> >> Are there references to 'created_on' missing?. I mean, i expected your >> 3rd line to be: >> max_created_on = t.max(created_on) >> >> and then use one of the two sides of the expression on the 5th line: >> db(query).select(t.device_id,**t.sensor_id,t.max(created_on),**... >> or >> db(query).select(t.device_id,**t.sensor_id,max_created_on,... >> >> also 4th line souldn't be...?: >> query = Expression(db,"date_sub(now(), interval interval_time minute) >> > created_on") >> >> >> Hope not to bother. >> Many thanks. >> >> >> BTW, i offer myself to help to improve some parts of the manual from the >> point of view of someone who is yet learning. >> >> Best regards, >> mcamel. >> >> >> On Friday, August 17, 2012 4:26:39 PM UTC+2, Massimo Di Pierro wrote: >>> >>> You can try this: >>> >>> from gluon.dal import Expression >>> t = db.abc_tbl >>> max_created_on = t.max() >>> query = Expression(db,"date_sub(now(), interval interval_time minute)") >>> db(query).select(t.device_id,**t.sensor_id,t.max(),group_by=** >>> t.device_id|t.sensor_id) >>> >>> On Thursday, 16 August 2012 23:01:44 UTC-5, Amit wrote: >>>> >>>> I have written one sql query: >>>> >>>> select device_id, sensor_id, max(created_on) from test.abc_tbl where >>>> date_sub(now(), interval interval_time minute) > created_on group by >>>> device_id, sensor_id; >>> >>> >>>> How to write it in web2py? >>>> >>>> Please help me to do the same. >>>> >>>> Thanks. >>>> >>> -- > > > > --
