OK. Ib trunk now: db(....).select(db.tbl_table.field2.abs().min())
On Thursday, 20 December 2012 05:20:15 UTC-6, Pradeeshnarayan wrote: > > In my web2py DAL query I want to calculate the absolute minimum value of a > field. > > I am trying to convert this sql query to DAL (mysql database) > select MIN(ABS(field2)) from tbl_table where field1='abc'; > > I have tried like below, but not correct > result = > db(db.tbl_table.field1==value).select(ABS(db.tbl_table.field2).min()) > > I would greatly appreciate any suggestions. > > > --