does grid error with alias joins?
ToSender = db.auth_user.with_alias('ToSender')
this query
query =((db.InternalMessage.recipientOfMessage == auth.user_id) & (db.
InternalMessage.recipientDelete == None) & (db.InternalMessage.recipientArchive
== None) & (ToSender.id == db.InternalMessage.created_by))
results in error below when grid uses it
'Row' object has no attribute 'id
But this DB with exact same fields (not used in grid) doesn't raise errors
query = db(((db.InternalMessage.recipientOfMessage == auth.user_id) & (db.
InternalMessage.recipientDelete == None) & (db.InternalMessage.recipientArchive
== None) & (ToSender.id == db.InternalMessage.created_by))).select()
thanks,
Alex Glaros
--
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/d/optout.