Hi all,
I'm having some difficulties with smartgrid and linked tables. My model is
as follows:
db.define_table('facility',
Field('facility_id','id'),
Field('name'),
Field('type'),
migrate=False)
db.define_table('server',
Field('server_id','id'),
Field('server_name'),
Field('facility_id', db.facility),
Field('active', 'boolean'),
Field('modified_date', 'datetime'),
migrate=False)
Note that because it is an existing database, the primary key is not called
"id" in the database but is defined as an ID type in the model. Not sure if
this is important.
The controller is as follows:
def index():
response.flash = "Welcome to the server view!"
linked_tables = ['facility']
servers = SQLFORM.smartgrid(db.server, linked_tables=['facility'],
user_signature=False, links_in_grid=True, editable=False, deletable=False)
return dict(servers=servers)
When the table renders, it doesn't display hyper-links for the facility IDs
as I would have expected.
Am I missing something?
Ciao,
Dominic.
--
