There's nothing magic about the table auth_user. You can look at it in the database view (appadmin) of your application and see its fields. For example, if you want to query for a last name, just use the same syntax you'd use on any other table:
db(db.auth_user.last_name.like('Barn%')).select(...) ...or... db(db.auth_user.first_name=='Joe').select(...) ...or... db(db.auth_user.username.contains('frog').select(...) -- Joe On Sunday, August 11, 2013 4:49:25 PM UTC-7, Hunt wrote: > > Hello, > > How would I go about querying the auth.user tables for a user with a > certain attribute? For a regular table I would do: > > comments = db(db.comments.some_attribute == lookingForThis).select() > > Not sure how to do this with the auth.user tables however. > > Thanks, > > Hunt > -- --- 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/groups/opt_out.