Thank you very much
but i have new problem it shows on right the links Auth memberships  Auth 
events   Auth cases ... 

and i'd like to select and not show all the linked tables

Le mercredi 31 mai 2017 17:45:17 UTC+2, Anthony a écrit :
>
> Use the "constraints" argument, which is a dictionary with table names as 
> keys and queries as values.
>
> SQLFORM.smartgrid(db.auth_user,
>                   constraints=dict(auth_user=db.auth_user.id == 2),
>                   ...)
>
> Anthony
>
> On Wednesday, May 31, 2017 at 11:03:06 AM UTC-4, LC LC wrote:
>>
>> Hi,
>> i'd like to have a conditional expression when i use smart grid, is it 
>> possible
>>     query=db(db.auth_user.id=='2').select()
>>     grid = SQLFORM.smartgrid(query,linked_tables=['coautor','aff'], 
>> user_signature=True)
>>
>> i know in the doc it is written "The first argument is a table, not a 
>> query"    
>>
>> But how can i do if i want to use linked tables ?
>>
>> thank you
>>
>

-- 
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.

Reply via email to