I see this was never answered, but I'm looking for the same thing. How
does SQLFORM.grid's 'selectable' determine which field to use for the
'ids'? I have a left join as well, and it is picking the 'id' field from
the wrong table. Is there a way to specify which table to use?
-Jim
On Monday, March 12, 2012 7:41:18 AM UTC-5, Johann Spies wrote:
>
> 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)
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
