So this fix isn't in the web2py 2.10.4 beta that was built on 4/18? -Jim
On Mon, Apr 20, 2015 at 4:55 PM, Niphlod <[email protected]> wrote: > we're waiting for 2.10.4 including > https://github.com/web2py/pydal/issues/135 > > On Monday, April 20, 2015 at 9:46:58 PM UTC+2, Jim S wrote: >> >> I posted in this thread >> https://groups.google.com/forum/#!topic/web2py/2i9zfAzG2s8 but posted >> after it was closed. Evidently, this is fixed but I'm still not seeing my >> 'formats' for foreign keys. Here are the details: >> >> I have this in my db.py: >> >> db.define_table('customer', >> Field('customerId', 'id', readable=True, writable=False, label='Customer >> #'), >> Field('name', length=30, required=True, writable=False, >> requires=IS_NOT_EMPTY()), >> Field('city', length=30, writable=False), >> Field('state', length=2, writable=False), >> format='%(customerId)s - %(name)s - %(city)s, %(state)s') >> >> db.define_table('equip_order', >> Field('id', 'id', readable=False, label='Order #'), >> Field('order_type', 'reference orderType', label='Order Type', >> ondelete='RESTRICT', >> requires = IS_IN_DB(db(db.orderType.equipment==True), >> 'orderType.id', '%(name)s', zero='..')), >> Field('status', length=10, default='New', >> requires=IS_IN_SET(('New', 'Submitted', 'Invoiced'))), >> Field('customer', 'reference customer', label='Customer', >> ondelete='RESTRICT')) >> >> When I display (VIEW MODE) the customer field in the equip_order table in >> a custom SQLFORM.grid form using: >> >> {{=form.custom.widget.customer}} >> >> ...it displays the id of the customer, not the name. >> >> I thought the 'format' on the customer table definition would control >> this. I know I can fix it by changing the definition of the customer field >> in the equip_order table to: >> >> Field('customer', 'reference customer', label='Customer', >> ondelete='RESTRICT', >> represent=lambda x, r: '%s - %s - %s, %s' % (db.customer(x).customerId >> db.customer(x).name, >> db.customer(x).city, >> db.customer(x).state) if x else ''), >> >> Should I have to do that, or should the 'format' on customer take care of >> it? >> >> -Jim >> > -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/j4MhaEfBNuQ/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > 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.
