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 > row:row.employee_number)] > > response.title = 'demo030' > response.view = 'plugin_sqleditable/sample.html' > editable = SQLEDITABLE(db.employee_sheet, > record=record(),showid=False, > > maxrow=5).process() > return dict(editable=editable) > > If you use "primarykey" and multiple key fields, you need to write list of > list in "record" parameter. > > > 2014-07-07 5:51 GMT-03:00 'kato' via web2py-users <web2py@googlegroups.com > >: > >> 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 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? >>> >>> Thanks, >>> >>> Fabiano >>> >>> >>> >>> 2014-07-01 10:12 GMT-03:00 'kato' via web2py-users < >>> web...@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. >>>> If you are interested, please try. >>>> >>>> Thanks. >>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to web2py+un...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "web2py-users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/web2py/PQE1JJwv0Bc/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> web2py+unsubscr...@googlegroups.com. >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
