created_by works because it references db.auth_user and db.auth_user has a
format attribute which specifies how it is to be represented. So, your
argument '%(name)s' gives it a label, but not a representation.
Add a format attribute to those other tables.
On Saturday, July 21, 2012 7:13:08 AM UTC-7, david.waldrop wrote:
>
> I have a table defined as follows:
>
> db.define_table('org',
> Field('name'),
> Field('otype',db.orgtypes, label='Type'),
> Field('jurisdiction',db.jurisdictions),
> Field('created_by',db.auth_user,readable=True,writable=False),
>
>
> Field('created','datetime',default=request.now,readable=False,writable=False),
>
>
> Field('last_activity','datetime',default=request.now,readable=False,writable=False),
>
>
> Field('deletedflag', comment='This flags the record as deleted,
> but does not remove.', writable=False, readable=False),
> migrate=migrate_db)
> db.org.name.requires = [IS_NOT_EMPTY(),IS_NOT_IN_DB(db, 'org.name')]
> db.org.otype.requires = IS_IN_DB(db, 'orgtypes.id', '%(name)s',
> zero=T('choose one'))
> db.org.jurisdiction.requires = IS_IN_DB(db, 'jurisdictions.id',
> '%(name)s', zero=T('choose one'))
> if auth.is_logged_in():
> db.org.created_by.default = auth.user.id
>
> and am trying to use SQLForm.grid like this - SQLFORM.smartgrid(db.org)
>
> The display shows the name of the create_by field by automatically looking
> up the id of the user who created the organization record, however neither
> the jurisdictio field, nor the otype field do the same. Both display the
> primary key instead of the appropriate names.
>
> A second issue that may be related in the actual display of the of the
> auto-rederenced user is David Waldrop (29) - where 29 is the primary key of
> the user. I would like to eliminate this as well as it means nothing to
> the user.
>
> I have played with represents, but cannot figure out why the behavior
> seesm inconsistent. Any suggestions are very much appreciated?
>
--
