The first one worked:information = auth.user.newfield
The second did not:rows = db(db.auth_user.id==auth.user.id
).select(db.auth_user.newfield)
On Friday, October 7, 2016 at 9:51:15 AM UTC-4, Marlysson Silva wrote:
>
> Don't worked?
>
> Em sexta-feira, 7 de outubro de 2016 10:48:45 UTC-3, Aydin escreveu:
>>
>> Thanks, information = auth.user.newfield worked as expected.
>> I just want to mentioned when I used
>> rows = db(db.auth_user.id==auth.user.id).select(db.auth_user.newfield)
>> it game me auth_user.newfielddata, data is the string stored in the
>> newfield.
>>
>>
>>
>> On Friday, October 7, 2016 at 9:40:59 AM UTC-4, Marlysson Silva wrote:
>>>
>>> Try:
>>>
>>> information = auth.user.newfield
>>>
>>> The auth.user contains a copy of auth_user table from current logged in
>>> user.
>>>
>>> Or:
>>>
>>> rows = db(db.auth_user.id==auth.user.id).select(db.auth_user.newfield)
>>>
>>>
>>> Em sexta-feira, 7 de outubro de 2016 10:00:51 UTC-3, Aydin escreveu:
>>>>
>>>> This is a simple question but I couldn't find the answer for it.
>>>> How can I read a custom field in the auth_user?
>>>> I have added a new field to auth_user table by:
>>>> auth.settings.extra_fields['auth_user']= [
>>>> Field('newfield','string')
>>>> ]
>>>>
>>>> now I want to read that value in the controller using db().select(...),
>>>> but how to say to select() to choose that field of the auth user?
>>>>
>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
