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.
