yes, you are right, db.auth_user will return all the users table.
please try to change
Field('hotel_chain_manager', db.auth_user)
into
Field('hotel_chain_manager', 'reference auth_user',
default=auth.has_membership('Admin'))
hope this can help
best regards
On Tuesday, May 7, 2013 7:24:05 AM UTC-4, José Manuel López wrote:
>
>
>
> Hi!,
> Thank you for your answer, but it's not exactly what I want.
> I'll explain better:
> Let's say I have this table:
> db.define_table('Hotel',
> Field('name', label="Nombre del Hotel "),
> Field('hotel_type', db.BookingCategory),
> Field('hotel_chain_manager', db.auth_user))
>
> And now I've a SQLFORM.grid like this:
>
>
> form = SQLFORM.grid(db.Hotel,
> searchable=True,
> deletable=True,
> details=True,
> selectable=False,
> create=True,
> sortable=True,
> fields=fields,
> paginate=100,
> maxtextlength=75,
> links_in_grid=True)
>
> as you can see, it is editable, but the Field "hotel_chain_manager" in the
> form will be populated with ALL the users in db. This is not what I want, I
> want that this field will be populated *only with the users in the
> "Admin" membership*.
>
> Kind Regards!!
>
> On Tuesday, May 7, 2013 10:36:04 AM UTC+2, 黄祥 wrote:
>>
>> i think you can achieve it (in controller using grid) with
>> editable = auth.has_membership('Admin')
>>
>> e.g.
>> def booking():
>> has_membership=auth.has_membership('Admin')
>> grid=SQLFORM.grid(db.booking, editable=has_membership)
>> return locals()
>>
>> best regards
>>
>> On Tuesday, May 7, 2013 3:16:11 PM UTC+7, José Manuel López wrote:
>>>
>>> Hi,
>>> I've a " form = SQLFORM.grid " that let the user edit the rows.
>>> In the edit form I want that one of the field populated only with
>>> "Admins". Now I have this field populated with all the db.auth_user and is
>>> huge and very hard to find the correct user.
>>> How can I do it?, I'm thinking in something like:
>>> *db.Hotel.chainManager **=IS_IN_DB( ¿¿??? )* .... how to express
>>> only users with Admin membership?.
>>>
>>> Thank you.
>>>
>>
--
---
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/groups/opt_out.
