Your reference field definitions are wrong -- you have defined them as
"integer" fields and passed "reference" as the third argument, which is the
"length" argument, not the "type" argument. Should be:
Field('project_id', 'references projects')
Anthony
On Sunday, March 6, 2016 at 10:40:00 AM UTC-5, David Orme wrote:
>
> I have a table like this:
>
> db.define_table('visit',
> Field('project_id', 'integer', 'references projects'),
> Field('arrival_date','date'),
> Field('departure_date','date'),
> Field('number_of_visitors','integer'),
> Field('purpose','text'),
> Field('proposer_id', 'integer', 'references auth_user'),
> Field('approval_status', 'string',
> requires=IS_IN_SET(['Yes','No','Pending']),
> default='Pending')
>
> I'm using SQLFORM.grid to see a list of Pending visits and allow admin
> users to click through to the SQLFORM for a given visit to set the approval
> status. This all works fine, except that I'd like the SQLFORM for a visit
> to substitute in the project name and proposer name from the two referenced
> tables, rather than just giving the ID numbers.
>
> I've tried playing around with passing in a joined query and using the
> 'left=' argument, but as far as I can tell you can only get the fields from
> a single table (although you can switch _which_ table using 'field_id=').
>
> My controller currently looks like this - I'm using editargs to control
> which field appear in the SQLFORM and I have tried including fields from
> joined tables in here, but with no success.
>
> @auth.requires_membership('admin')
> def visit_admin_old():
>
> # don't want the admin to change any of this about a visit
> db.visit.project_id.writable = False
> db.visit.proposer_id.writable = False
> db.visit.arrival_date.writable = False
> db.visit.departure_date.writable = False
> db.visit.number_of_visitors.writable = False
> db.visit.purpose.writable = False
>
> # get a query of pending requests with user_id
> form = SQLFORM.grid(query=(db.visit.visit_status == 'Pending'), csv=
> False,
> fields=[db.visit.arrival_date,
> db.visit.departure_date,
> db.visit.number_of_visitors,
> db.visit.purpose],
> maxtextlength=250,
> deletable=False,
> editable=True,
> create=False,
> details=False,
> editargs = {'fields': ['project_id','proposer_id'
> ,
> 'arrival_date',
> 'departure_date',
> 'number_of_visitors',
> 'purpose',
> 'visit_status',
> 'visit_decision_notes'],
> 'showid': False})
>
> return dict(form=form)
>
> Thanks in advance,
> David
>
>
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
