Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilità
Magazzino
PoS
Progetti
MRP

All apps

Tutti gli articoli Persone Badge

Etichette (Mostra tutto)

odoo accounting v14 pos v15

Sul forum

Assistenza

Getting the department_id through the user on domain filter

filter rule rules

7 Risposte

32240 Visualizzazioni

Kevin Carlo Samaniego

How do I access the department_id through the user.id on a domain filter?

I created a rule with Leave as the object. My goal is to have the user see leaves only from employees of his/her department. I see that an employee is connected to the user by user.id and employee contains the field department_id.

None of the following domain filters worked:

[('department_id','=',user.id.employee_id.department_id)]

[('department_id','=',['employee_id.user_id','=',user.id,'.','department_id'])]

[('department_id','=','employee_id.user_id')]

Stefan Wailand

Risposta migliore

I would say this is the right answer:

<field name="domain_force">[('department_id.member_ids.user_id', 'in', [user.id])]</field>

Explanation:

user.id" - in the data model of OpenERP for res_users no way to hr_employee is possible
therefore department_id.member_ids will just give back a list with employee_ids
in hr.employee the field user_id is available - therefore the path deparment_id.member_ids.user_id is the right way

SOUJIRO30

Try this one: (Settings > Technical > Record Rules)

<record id="record_rule_id" model="ir.rule">

<field name="name">Your Rule Name</field>

<field name="model_id" ref="module.your_model_id"/>

<field name="domain_force">['|', ('department_id', '=', False), (' department_id ','child_of',[user. department_id .id])]</field>

<field name="perm_write" eval="1"/>

<field name="perm_create" eval="1"/>

<field name="perm_read" eval="1"/>

<field name="perm_unlink" eval="1"/>

</record>

I hope this may help you.

Ghanshyam Prajapati

Try Following,

domain = "[('department_id','=',user.id.employee_id.department_id)]" in your xml file.

Hope it work for you.

Kevin Carlo Samaniego

Autore

On what particular XML file do I add it and where is it located? I tried adding the rule on ir_rule.xml under the security folder of the hr_holidays addon but it still doesn't work. Thanks for the answer.

Ghanshyam Prajapati

Put this domain on your field, suppose you field is xyz, then add <field name="xyz" domain="[('department_id','=',user.id.employee_id.department_id)]" />

Kevin Carlo Samaniego

Autore

I found another way around and it worked. I used this domain filter instead: [('department_id.member_ids','=',user.id)] Thanks again.

kenneth mallari

Hello kevin, nasolve mo ba ung problem mo sa domain filter? hindi ko kc makuha sakin.

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!

Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!

Registrati

Post correlati	Risposte	Visualizzazioni
How do I create a rule definition to filter leaves by the logged in user's department? filter leaves rule rules	1 mar 15	7469
Unable to create a customer as an ordinary user when applying a Record rule in openerp7 filter domain rule record rules	0 mar 15	4892
Salesperson own and new documents domain filter. Risolto filter domain rule	1 ott 21	3180
Need help with a filter domain filter domain rules	0 mar 15	4092
How to override/delete the rule from inherited group? hr rule rules groups	0 feb 19	6257

La domanda è stata contrassegnata

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!