groups returns a TABLE(), not a list of records. On Tuesday, October 30, 2012 5:57:03 PM UTC+1, Richard wrote: > > I didn't test, but you may try this : > > for row in auth.groups(): > print row > > row should contain the different column of auth_group table and you can > usually get those column like this row.name (column name in this example). > > You could also try as_list() : > > http://web2py.com/books/default/chapter/29/06#as_dict-and-as_list > > If it doesn't work, use the query I wrote above : > > rows = query > for row in rows: > do stuff > > Richard > > On Tue, Oct 30, 2012 at 12:35 PM, Francisco Barretto > <[email protected]<javascript:> > > wrote: > >> Ok Richard, I've got it. You are right. Without parameters it works but I >> cant manage to get a userfull list out of it. Accesint the webpage doesn't >> help either, since I need to compare memberships inside the controller >> actions. >> >> I would need a list containing all user groups but I got instead, some >> kind of raw table which I don't know how to iterate with. >> >> Can you help me go further? >> >> Thanks, mate! >> >> >> On Tuesday, October 30, 2012 2:07:40 PM UTC-2, Richard wrote: >> >>> Ok! >>> >>> I read the book. >>> >>> You should not pass the user id. >>> >>> auth.groups() and not auth.groups(auth.user.id) >>> >>> Also you can go to this URL : >>> >>> http://127.0.0.1/yourappname/**default/user/groups<http://127.0.0.1/yourappname/default/user/groups>and >>> you will get the list of group your current logged user is in. >>> >>> Richard >>> >>> On Tue, Oct 30, 2012 at 11:51 AM, Richard Vézina >>> <[email protected]>wrote: >>> >>>> I don't know if web2py has a given command or how to use it, but this >>>> query should give you what you the information you are searching : >>>> >>>> db((db.auth_user.email == 'USER_EMAIL')&(db.auth_**membership.user_id >>>> == db.auth_user.id)&(db.auth_**group.id <http://db.auth_group.id> >>>> ==db.auth_membership.**group_id)).select(db.auth_**group.ALL) >>>> >>>> Richard >>>> >>>> >>>> On Tue, Oct 30, 2012 at 11:15 AM, Francisco Barretto < >>>> [email protected]> wrote: >>>> >>>>> Hi Folks! >>>>> >>>>> How do I list all groups that a user belong? I've found out that Auth >>>>> has this function: >>>>> >>>>> groups(self) >>>>> displays the groups and their roles for the logged in user >>>>> >>>>> I dont manage to get it working. I've tried something like this: >>>>> >>>>> def myGroups(): >>>>> return dict(auth.groups(auth.user_id)**) >>>>> >>>>> and get this error: >>>>> <type 'exceptions.TypeError'> groups() takes exactly 1 argument (2 >>>>> given) >>>>> >>>>> any idea on how to do this properly? Thanks! >>>>> >>>>> -- >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> -- >> >> >> >> > >
--
