VIEW NAME NOT ID

[Ayron Rangel]

 I have this:

db.py:

db.define_table('product_input',

    Field('product', db.product, notnull=True),

    Field('total_price','decimal(7,2)', readable=False,writable=False),

    Field('amount', 'integer', readable=False,writable=False),

    Field('supplier', db.supplier, notnull=True),

    Field('location', db.location, notnull=True),

    Field('input_type', 'string'),

    auth.signature,

    format = lambda r: '%s %s %s %s  [%s]' % (r.product.model.model, r.product.manufacturer.manufacturer, r.product.part_number, 

       r.product.serial_number, r.product.expiration_date)

    

    )

default.py: 

def stock():

    count = db.product_input.id.count()

    results = db(db.product_input).select(db.product_input.product, count, groupby=db.product)

    return locals()

view: 

{{for row in results:}}

<tr>

<td>{{=row[db.product_input.product]}}</td>

<td>{{=row[count]}}</td>

</tr>

{{pass}}

APPEARS JUST THIS:

Product in Stock [Model]	Amount
6	2
7	2

HOW CAN APPEARS THE NAME NOT THE ID ON DE LINE?

[Dave S]

You need to tell web2py to display a reference field by the appropriate value; the index value is the default.

See 

<URL:http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#format--Record-representation>

and the example in
<URL:http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#One-to-many-relation>

/dps

[Ayron Rangel]

Sorry, man!

How can I put on my way?? based on my code!! 

 

 

[pbreit]

Are you trying to do something like this?

http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Grouping-and-counting

[Peter]

instead of this code:

<td>{{=row[db.product_input.product]}}</td>

try this (not tested) 

<td>{{=row.product.SOME_FIELD_NAME_FROM_PRODUCT_TABLE}}</td>