why the same query not work when i use it on smartgrid?
e.g.
def report_doctor():
query = (
(db.auth_user.id == db.auth_membership.user_id) &
(db.auth_membership.group_id == db.auth_group.id) &
(db.auth_group.role.like('doctor'))
)
#constraints = dict(auth_user = query)
constraints = {'auth_user' : query}
    grid = SQLFORM.smartgrid(db.auth_user, constraints = constraints)
    return locals()

it return an error :
Error snapshot [image: 
help]<http://127.0.0.1:8000/admin/default/ticket/clinic/127.0.0.1.2013-11-09.08-54-12.1bf94417-c0a1-4922-8236-513068d1d392#>
Detailed traceback description

<type 'exceptions.AttributeError'>('Row' object has no attribute 'address')

thanks and best regards,
stifan

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

Reply via email to