When using the following grid:
query = ((db.akb_authors.id.belongs(ids))&
(db.akb_authors_article_link.author == db.akb_authors.uuid)&
(db.akb_authors_article_link.article == db.akb_articles.uuid)&
(db.akb_journal.uuid == db.akb_articles.journal))
left = (db.akb_authors_article_link.on((db.akb_authors.uuid ==
db.akb_authors_article_link.author)&
(db.akb_authors.id.belongs(ids))&
(db.akb_authors_article_link.author == db.akb_authors.uuid)&
(db.akb_authors_article_link.article == db.akb_articles.uuid)&
(db.akb_journal.uuid == db.akb_articles.journal)))
fields = [db.akb_authors.id, db.akb_authors.surname,
db.akb_authors.firstname,
db.akb_authors.name, db.akb_authors.birthdate,
db.akb_authors.gender,
db.akb_authors.race, db.akb_authors.address,
db.akb_journal.title,
db.akb_journal.subject ]
headers = {'akb_journal.title': 'Journal'}
form = SQLFORM.grid(query, fields=fields, maxtextlength = 100,
deletable = False,
editable = False,
details = False,
create = False,
headers = headers,
selectable = lambda ids: hanteer_verfyning(ids),
orderby = db.akb_authors.auth_id|db.akb_authors.id)
the grid use the id's of the akb_articles. Is there an easy way to
convince it to use the id specified in [fields] in stead?
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
