Hello
when I try to create a left join between two tables I get an error
Attribute not found.
'Table' object has no attribute 'type'
I have lots of left joins in my code and this is the first time I am
experiencing this kind of error.
Any ideas
my query:
workers_infos = db((query_wi)&(db.workers_info.wi_organization == org) &
(db.workers_info.wi_worker.belongs(set(workers_id)))).select(db.workers_info.id,
db.workers_info.wi_date,
db.workers_info.wi_get_info,
db.workers_info.wi_hour,
db.workers_info.wi_vacation,
db.workers_info.wi_worker,
db.workers_info,
db.workers_info.wi_vacation_past,
db.workers.id, db.workers.w_day_obligation,
db.workers.w_work_type,
db.workers.w_hour_formula,
left=db.workers.on(db.workers.id==db.workers_info.wi_worker)
).as_list()
--
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.