This gives you a list of all record you can "read" db(db.auth_permission.name=="read")& (db.auth_permission.table_name=="yourtable")& (db.auth_permission.group_id==db.auth_membership.group_id)& (db.auth_membership.user_id==auth.user.id)).select (db.auth_permission.record_id)
record_id=="0" indicates (all records in the table "yourtable"). You can combine the above query with a query to your table. I suggest you write a function that does it. Massimo On Apr 2, 4:29 am, kellda <dan...@kellnet.ch> wrote: > Using auth.has_permission for a single record (update, read) is clear > for me but how to check the permission in a form with a list of > records? > > def list(): > records=db((db.test.id>0)).select() > return dict(records=records) > > how to filter only the records with the permission? Do I have to check > this in the the form > > {{=for record in records}} {{if has_permission ..}} > > or can I do this in the controller? > > Thanks > Daniel --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---