Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
select * from hr_employee he, ( select he.id id,rr.user_id uid,he.name_related as nam,ru.login login from hr_employee he inner join ( res_users ru inner join resource_resource rr on rr.user_id = ru.id and ru.id = CURRENT_USER_ID ) on he.resource_id = rr.id ) as t where he.parent_id=t.id
I want to make the above SQL statement record rule.
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 5/31/13, 3:05 AM|
|Seen: 1322 times|
|Last updated: 10/5/15, 2:47 AM|