I could create a new auth method that allows:

db(auth.accessible(db.yourtable,"read")&..yourquery..).select
(db.yourtable.ALL)

but it would not work on GAE because of the JOIN. Should I add it
anyway?

Massimo

On Apr 2, 8:54 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to