SQLFORM grid returns a error : query object has no attribute _tablename

[Sarbjit singh]

I am doing the following steps :

>>> db = DAL('sqlite://storage.db')
>>> db.define_table('person', Field('name'), Field('country'))
>>> db.person.insert(name='John', country='UK')
>>> db.person.insert(name='David', country='US')
>>> query = db.person.name=="David"

>>> SQLFORM.smartgrid(query)

Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "....\gluon\sqlhtml.py", line 2459, in
smartgrid
    if request.args(len(args)) != table._tablename:
AttributeError: 'Query' object has no attribute '_tablename'

While if I try the below code, it works fine.

>>> db(query).select()

Can some one please point me why this query is not working with "smartgrid".

Thanks
Sarbjit

[Massimo Di Pierro]

Answered in other thread...

SQLFORM.grid(query) OK

SQLFORM.smartgrid(table) OK

SQLFORM.smartgrid(query) WRONG!

SQLFORM.smartgrid(table, contraints={'tablename':query}) OK

[Ron Chatterjee]

Responding to this old post.

    query = db.Project.created_by == auth.user_id;

    

    if_author = lambda row: (row.created_by==auth.user_id)

    #grid = SQLFORM.smartgrid(db.Project, constraints={'db.Project':query},editable=if_author,deletable=if_author,details=True,create=False,csv=False) #doesn't work

    grid = SQLFORM.grid(query,editable=if_author,deletable=if_author,details=True,create=False,csv=False)#works 

why?

[Anthony]

Instead of {'db.Project': query}, it should be {'Project': query}. db.Project is a Table object, but "Project" is the table name.

Anthony