Odoo Help

Welcome!

This community 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.

1

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

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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