[web2py] ABS function inside DAL query

[Pradeeshnarayan]

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.


--