Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
filterrulerules
7 Odpovědi
32358 Zobrazení
Avatar
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')]

Avatar
Zrušit
Avatar
Stefan Wailand
Nejlepší odpověď

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
Avatar
Zrušit
Avatar
SOUJIRO30
Nejlepší odpověď

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.

Avatar
Zrušit
Avatar
Ghanshyam Prajapati
Nejlepší odpověď

Try Following,

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

Hope it work for you.

Avatar
Zrušit
Kevin Carlo Samaniego
Autor

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
Autor

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

Avatar
kenneth mallari
Nejlepší odpověď

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

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
How do I create a rule definition to filter leaves by the logged in user's department?
filter leaves rule rules
Avatar
Avatar
1
bře 15
7528
Unable to create a customer as an ordinary user when applying a Record rule in openerp7
filter domain rule record rules
Avatar
0
bře 15
4933
Salesperson own and new documents domain filter. Vyřešeno
filter domain rule
Avatar
Avatar
1
říj 21
3255
Need help with a filter domain
filter domain rules
Avatar
0
bře 15
4151
How to override/delete the rule from inherited group?
hr rule rules groups
Avatar
0
úno 19
6338