Where is defined the user_id field of the model hr_employee?

Question

Hello all,
I'm on odoo 10.
1) After an hour searching, I can't find where is *declared* the many2one field *user_id* of the model* hr_employee*... Where is the 'user_id = fields....' in the Python code?
2) Also, still in the model *hr_employee*, why this sql works :
select distinct("resource_id") FROM "hr_employee" where "resource_id" is not null But not this one (ERROR:  column "user_id" does not exist) :
select distinct("user_id") FROM "hr_employee" where "user_id" is not null
Both fields* res

Sudhir Arya (ERP Harbor Consulting Services) · Accepted Answer

Hi Pascal,
The user_id (Related User) field is created in resource module resource. [1] resouce [2] object and hr.employee inherits resource [3] object.
So basically you have to use join query to fetch the user_id field.
SELECT resource.user_id FROM hr_employee emp
LEFT JOIN resource_resource resource ON res.id=emp.resource_id Hope this will help you,
Thanks

[1] https://github.com/odoo/odoo/blob/8.0/addons/resource/resource.py#L671
[2] https://github.com/odoo/odoo/blob/8.0/addons/resource/reso

Fidel Jimenez Sanzano · Answer

The employee is a resource and the resource is the one that has a user_id. Following with the example in sql should be.
Select distinct user_id
from hr_employee e inner join resource_resource res ON e.resource_id=res.id
where user_id is not null Or use the ORM employee.user_id
Sorry my english is not very good
i hope this are usefull for you

Related Posts	Replies	Views
Odoo14 Creating user automatically creates employee Solved user employee	1 Mar 21	5985
Same user can be allocated to multiple employees!!!! user employee	4 Mar 15	12982
should a real employee be linked to the user Administrator? user employee	2 Mar 15	7594
Trying to create a res.user record in code user employee custommodule	1 Nov 23	7123
How to link Employee to User for Timesheet to work properly? Solved user employee timesheet	1 Mar 24	7892

This question has been flagged

Enjoying the discussion? Don't just read, join in!