Hi martín, And with powergrid? -- Enviado desde mi teléfono Android con K-9 Mail. Disculpa mi brevedad
"Martín Mulone" <mulone.mar...@gmail.com> escribió: Perhaps you want to use columns instead of fields. replace your controller with this: def index(): columns = ['dog.name', 'dog.owner'] table = SQLFORM.grid(db.dog, columns=columns) return dict(table=table) columns affect the grid column displaying only. Pass to column the field you want to display, no need to put readable=False. 2011/9/14 Simon Ashley <gregs...@gmail.com> While it could be a bug, and seems to be similar to another reported issue: http://groups.google.com/group/web2py/browse_thread/thread/aa5fa98a74e9364f# there has been no formal acknowledgement of it in .grid or .smartgrid, nor have there been any defect tickets raised. You can also see it in a screenshot that Bruno Rocha posted recently: http://www.diigo.com/item/image/121xl/3iob It leads me to think that there may be an alternative method, particularly when 1.99.1. is due shortly. Cheers, (apologies if there are a number of similar posts from me. The first 2 seemed to be accepted, but haven't appeared yet. This is posted using a different account) On Sep 14, 12:11 am, Jim Steil <j...@qlf.com> wrote: > Is it possible that this is a bug? (I don't have the > expertise/confidence to say it is definitely a bug). I duplicated > your example and can reproduce your results. But, if I go through > appadmin and list out my table the owner name does appear. > > -Jim > > On 9/12/2011 9:51 PM, Simon Ashley wrote: > > > > > > > > > Have a Model as follows: > > > from gluon.tools import Auth > > auth=Auth(db) > > auth.define_tables() > > db.define_table('person',Field('name'),format='%(name)s') > > db.define_table('dog',Field('name'),Field('owner',db.person)) > > db.dog.owner.requires = IS_IN_DB(db, 'person.id', db.person._format) > > > and a controller: > > > def index(): > > db.dog.id.readable=False > > fields = (db.dog.id, db.dog.name, db.dog.owner) > > table = SQLFORM.grid(db.dog, fields) > > return dict(table=table) > > > Main issue: > > the grid returns the id rather than the name for the owner. > > Edit and view both return the name (as expected). > > Is there a problem with the model/ controller syntax? > > > Side issue: > > In the controller, fields line, if db.dog.id is left out, the grid > > returns an id ticket error. > > > Traceback (most recent call last): > > File "gluon/restricted.py", line 194, in restricted > > File "C:/web2py/applications/pt2/controllers/dogs.py", line 7, in > > <module> > > File "gluon/globals.py", line 145, in<lambda> > > File "C:/web2py/applications/pt2/controllers/dogs.py", line 4, in > > index > > File "gluon/sqlhtml.py", line 1647, in grid > > File "gluon/dal.py", line 3835, in __getitem__ > > KeyError: 'id' > > > This occurs with or without the second line (... readable=False) > > commented out. > > Wanted to show the id in edit and view forms but not in the grid. > > Can this be achieved? -- http://martin.tecnodoc.com.ar
