I think you need to flip it around, and use facilities instead of servers,
and then you will get the link to servers:
facilities = SQLFORM.smartgrid(db.facility, linked_tables={},
user_signature=False, links_in_grid=True, editable=False, deletable=False)
return dict(facilities=facilities)
On Tue, Sep 25, 2012 at 5:06 AM, Dominic Cioccarelli <
[email protected]> wrote:
> 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.
>
> --
>
>
>
>
--
