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.

Reply via email to