Wow... for some reason I had it in my mind that it was something way more
complicated.
Thanks Joe!
On Sunday, August 11, 2013 10:36:38 PM UTC-4, Joe Barnhart wrote:
>
> 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.
