Re: [web2py] SQLEDITABLE plugin

Hi fabiano. It is not possible to pass a query currently. But record parameter is so callable, please set there. Please see to the demo5 http://docs1.erp2py.com/sqleditable/demo/demo_en.html#demo5 . thanks. 2014年7月6日日曜日 15時19分04秒 UTC-3 Fabiano Almeida: Hi kato! How to use SQLEDITABLE

Re: [web2py] SQLEDITABLE plugin

I will add a postscript. you can write as below. def demo031(): def record(): rows = db(db.employee_sheet.resigned == True).select(limitby=(0,3)) return [row.id for row in rows.sort(lambda row:row.employee_number)] response.title = 'demo030' response.view =

Re: [web2py] SQLEDITABLE plugin

Thanks Kato!!! Now I get it!! 2014-07-07 8:30 GMT-03:00 kato hi21...@gmail.com: I will add a postscript. you can write as below. def demo031(): def record(): rows = db(db.employee_sheet.resigned == True).select(limitby=(0,3)) return [row.id for row in rows.sort(lambda

Re: [web2py] SQLEDITABLE plugin

Hi kato! How to use SQLEDITABLE with a query? If I try this in your first example: query = db.employee_sheet.resigned == True editable = SQLEDITABLE(query, showid=False, maxrow=5).process() Return error: AttributeError: 'Query' object has no attribute '_id' How to filter table?

Re: [web2py] SQLEDITABLE plugin

Very Nice! Thank you very much! 2014-07-01 10:12 GMT-03:00 'kato' via web2py-users web2py@googlegroups.com : Hi. I tried to make SQLEDITABLE plugin. demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.