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.
>>
>
--
