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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
