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.


Reply via email to