I just grabbed the latest, timestamp looks like this: Version 2.10.4-beta+timestamp.2015.04.20.18.00.31
and still having the same issue. -Jim On Monday, April 20, 2015 at 6:03:03 PM UTC-5, Massimo Di Pierro wrote: > > re-pushing. Check the nightly built in 20 minutes. > > On Monday, 20 April 2015 16:58:04 UTC-5, Jim S wrote: >> >> 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] <javascript:>> >> 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] <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.
