Hi Anthony,
This is seem not work in case self reference.
Ex :
Field('boss', 'reference auth_user')
How can I solve in this situation?
Thanks,
On Monday, October 8, 2012 9:17:49 AM UTC+7, dave wrote:
> Thank you very much, I did not see this in the documentation and yes it
> would be nice if it is consistent with your expectation
>
> On Sunday, October 7, 2012 6:25:09 PM UTC-7, Anthony wrote:
>>
>> If you do:
>>
>> Field('test1', 'reference ranking')
>>
>> and then make sure the "format" attribute of the "ranking" table is set
>> to '%(name)s', then the "test1" field will automatically get the IS_IN_DB
>> validator you have explicitly defined below, and it will automatically get
>> a "represent" attribute displaying the "name" value from the "ranking"
>> table. However, if you explicitly define your own "requires" attribute,
>> then you don't get the automatic "represent" attribute, and you have to
>> explicitly define that as well (I think we should probably change this,
>> though).
>>
>> Anthony
>>
>> On Sunday, October 7, 2012 2:44:44 PM UTC-4, dave wrote:
>>>
>>> auth.settings.extra_fields['auth_user']= [
>>> #Field('name', requires=IS_NOT_EMPTY()),
>>> .
>>> .
>>> .
>>> Field('test1', 'reference ranking', requires=IS_IN_DB(db, 'ranking.id'
>>> , '%(name)s')),
>>> .
>>> .
>>> .
>>>
>>>
>>> On Sunday, October 7, 2012 7:37:03 AM UTC-7, Anthony wrote:
>>>>
>>>> How is your "test1" field defined?
>>>>
>>>> On Sunday, October 7, 2012 3:26:31 AM UTC-4, dave wrote:
>>>>>
>>>>>
>>>>> grid = SQLFORM.grid(query, args=[request.args(0)],
>>>>> fields=[db.auth_user.test0,
>>>>> db.auth_user.test1,
>>>>> db.auth_user.test2,
>>>>> I have defined this in my controller, the value of test1 is a
>>>>> reference to another table, how would I make web2py show the referenced
>>>>> value instead of displaying the id, something equivalent to
>>>>> Field('field2',
>>>>> 'reference employees', requires=IS_IN_DB(db, 'employees.id',
>>>>> '%(name)s')) when defining the table
>>>>>
>>>>
--
---
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.
