I'm trying to make a smartgrid using a table that has references to other
(auth_user). The smartgrid show up but it does not include the field where
I reference the other table.
with code:
-- in the db:
auth = Auth(db, hmac_key=Auth.get_or_create_key())
crud, service, plugins = Crud(db), Service(), PluginManager()
## create all tables needed by auth if not custom tables
auth.define_tables()
...
db.define_table('attachment',
Field('name'),
Field('filename'),
Field('submitted_by', db.auth_user, default=None, readable=False,
writable=False),
format='%(name)s')
-- in the controllers:
def show_files():
form = SQLFORM.smartgrid(db.attachment)
return dict(form=form)
The generated smargrid does not show the "submitted_by" field. How can I
make that happen?
I would like to see auth_user representation and if I click on it brings
the complete auth_user entry.
Thank you
P.S.: In the book there is an example that shows the "opposite" of what I
want to do using the linked_tables=[] parameter that allows us to drill
down from a parent smartgrid into a child.
