to get a GAE projection query you have to specify projection=True in your query:
db(db.auth_user.id==user_role.user_id).select(db.auth_user.first_name, projection=True) why? well, for backwards compatibility reasons. prior to projection queries being supported on GAE the default behavior was to return all columns. when we added projection support i didn't want to break my existing apps that sometimes list fields, but don't have the projection indexes. let us know if that doesn't fix it for you! cfh On Monday, May 6, 2013 12:17:44 AM UTC-7, José Manuel López wrote: > > Hi, > I've to make an adHoc user management formulary and I'm making a table > with a "role filter". I'm in GAE and the joins must to be done by hand. > This is my code: > auth_user_with_role = db(db.auth_membership.group_id==request.vars.role). > select(db.auth_membership.ALL) > auth_user_ids_role_selected=db(db.auth_user.id<1).select(db.auth_user. > first_name) #This is a Hack, prob I can make it better > for user_role in auth_user_with_role: > user = db(db.auth_user.id==user_role.user_id).select(db.auth_user. > first_name) > auth_user_ids_role_selected = auth_user_ids_role_selected & user > > With this code I have a join between the group table and the user table. > The problem is that in user I have the user with all the columns and not > with only the "first_name" column. Is the projection not working or am I > doing something wrong? > Thank you guy for your help > -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
