readable and writable need to be true on the submitted_by field.
-Jim
On 4/9/2012 11:44 AM, blackthorne wrote:
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.
