Hi Richard,
I tries this, but it still comes back as a long
db.define_table('vendors',
Field('name','string'),
Field('vendor_location','string'),
format='%(name)s', migrate=True)
db.define_table('product',
Field('product_code','string'),
Field('product_name','string'),
Field('product_price','string'),
Field('product_owner', 'reference vendors', represent=lambda id,
row: db.vendors(id).name if id else T('N/A')),
Field('description','text'),
Field('image','string', label='Image Path'),
#Field('product_picture', 'upload',
uploadfield='product_picture_file'),
#Field('product_picture_file', 'blob'),
migrate=True)
On Tuesday, July 14, 2015 at 3:11:18 PM UTC-4, Richard wrote:
>
> Why not defining a representation for your product_owner field??
>
> Field('product_owner', 'reference vendors',
> represent=lambda id, row: db.vendors(id).name if id else
> T('N/A')),
>
>
> ???
>
> Richard
>
> On Tue, Jul 14, 2015 at 2:48 PM, LoveWeb2py <[email protected]
> <javascript:>> wrote:
>
>> I'm aware of the name method, Sam. The trouble I'm having is if I have
>> multiple records how could I put them in json format. I was hoping I
>> wouldn't have to iterate through the record and use the .name method
>>
>>
>> On Tuesday, July 14, 2015 at 2:32:36 PM UTC-4, Samuel Sowah wrote:
>>>
>>> you can do
>>> db(db.vendors.id==products.first().product_owner).select().first().name
>>> to get the name.
>>>
>>> The actual value stored in the db is the id. format helps with select
>>> drop-downs and viewing db records in the appadmin. As far as I know, that's
>>> how it works but I'd be happy to learn if there are other ways to achieve
>>> what you're looking for.
>>>
>>> On Tuesday, July 14, 2015 at 6:07:39 PM UTC, LoveWeb2py wrote:
>>>>
>>>> Hello,
>>>>
>>>> My goal is to represent the name instead of the field id here is my
>>>> model:
>>>>
>>>> db.define_table('vendors',
>>>> Field('name','string'),
>>>> Field('vendor_location','string'),
>>>> format='%(name)s', migrate=True)
>>>>
>>>> db.define_table('product',
>>>> Field('product_code','string'),
>>>> Field('product_name','string'),
>>>> Field('product_price','string'),
>>>> Field('product_owner', 'reference vendors'),
>>>> Field('description','text'),
>>>> Field('image','string', label='Image Path'),
>>>> #Field('product_picture', 'upload',
>>>> uploadfield='product_picture_file'),
>>>> #Field('product_picture_file', 'blob'),
>>>> format=lambda r: '%s' % (r.product_owner.name), migrate=True)
>>>>
>>>>
>>>> The problem is when I try to select the field it only shows me the id
>>>> and not the name of the referenced record. I've seen a few of Anthony's
>>>> post, but I can't seem to wrap my head around what's happening.
>>>>
>>>> Here you'll see it returns the product_owner as 2L instead of the
>>>> actual name of the owner. Is my format/representation messed up in my
>>>> model?
>>>>
>>>> In [1]: products = db(db.product.id>0).select()In [2]: products.first()
>>>> Out[2]: <Row {'product_owner': 2L, 'description': 'This is my product
>>>> description', 'image': '../static/images/image2.png', 'id': 1L,
>>>> 'product_price': '13.99', 'product_code': '0001', 'product_name': 'my
>>>> great
>>>> product'}>
>>>>
>>> --
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
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.
