I need these joins because I need filter some tables without selecting all
the tables and filtering with where. Anyway, I tried:
rows = (db.groups.id == db.lab.group_id)(db.lab.id ==
db.researcher_lab_permission.lab_id)(db.researcher.id ==
db.researcher_lab_permission.researcher_id)(db.researcher.user_id ==
db.auth_user.id).select(db.groups.name,db.city.name,db.auth_user.ALL)
And it returns:
<type 'exceptions.TypeError'> 'Query' object is not callable
I'm using db.executesql and it's working:
db.executesql('''SELECT l.id,g.name,c.name FROM researcher_lab_permission
as rl JOIN lab as l
JOIN researcher as r JOIN auth_user as a JOIN groups as g
JOIN city as c
ON rl.researcher_id = r.id AND rl.lab_id = l.id AND a.id =
r.user_id AND l.group_id = g.id
AND c.id = g.city_id WHERE a.id = %s''' %(auth.user_id))
Something strange with DAL...
2013/10/28 Massimo Di Pierro <[email protected]>
> (db.groups.**id <http://db.groups.id/> == db.lab.group_id)(db.lab.id ==
> db.researcher_lab_permission.**lab_id)(db.**researcher.id<http://db.researcher.id/>
> == db.researcher_lab_permission.**researcher_id)(db.researcher.**user_id
> == db.auth_user.id).select(db.groups.name,db.**city.name<http://db.city.name/>
> ,db.auth_user.ALL)
--
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.
