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
