>
>
> db.define_table('gender', Field('name'), format='%(name)s')
> db.define_table('person', Field('name'), Field('gender_id','reference
> gender'), format='%(name)s')
> db.define_table('thing', Field('name'), Field('owner_id','reference
> person',format='%(name)s')
>
> with this controller:
>
> @auth.requires_login()
> def mytest():
> grid=SQLFORM.smartgrid(db.thing)
> return dict(grid=grid)
>
>
> the owner_id's name is displayed when function above is called, but if I
> want to restrict owner_id (to male only for example) with this :
>
> db.thing.owner_id.requires=IS_IN_DB(db(db.person.gender_id==db.gender(name
> ='M').id),'person.id')
>
> Are you saying the problem is with the display of the "owner_id" values in
the grid itself, or in the drop-down in create/edit forms? The above code
will not affect the display in the grid, only in drop-downs (unless your *
real* code sets the "requires" attribute directly in the "thing" table
definition rather than after the fact as shown above).
Assuming the problem is in the dropdown, note that IS_IN_DB takes a "label"
argument, which you can set to the _format attribute of the referenced
table:
db.thing.owner_id.requires=IS_IN_DB(db(db.person.gender_id==db.gender(name=
'M').id),
'person.id', db.person._format)
Note, if you set the "requires" attribute of the reference field within the
table definition itself (i.e., via Field(..., requires=...)), then you will
not get the default "represent" attribute, which means the grid itself will
only display the id's.
Anthony
--
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/groups/opt_out.
