Odoo Help

1

How can we write this sql statements in format of domain?

By
576832048
on 5/31/13, 3:05 AM 1,095 views
 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.

Any help,thanks

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

Question tools

0 follower(s)

Stats

Asked: 5/31/13, 3:05 AM
Seen: 1095 times
Last updated: 10/5/15, 2:47 AM