Skip to Content
This question has been flagged
xmlrulesgroupsodoo
2 Replies
3351 Views
Avatar
yasmina

The rule is not working, when I add faculty in res.user or when I delete one.



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

            <field name="name">User inscription</field>

            <field name="model_id" ref="model_inscription"/>

            <field name="groups"

                   eval="[(4, ref('tutorat.group_admin'))]"/>

            <field name="domain_force">[('faculty_id', 'in', user.faculty_id.ids)]</field>

        </record>

  • In class inscription

departement = fields.Many2one('department', 'Département')

faculty_id = fields.Many2one('faculty', string='Faculté',related='departement.faculty_id')

  • In class res.user

faculty_id = fields.Many2many('faculty', string='Faculté')





Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

The record rule is not working because ‘faculty_id’ in the model ‘inscription’ is a related field without store=True.

Record rules work at SQL level, so the field must be stored in the database. In inscription model .py file update the field definition like this:-

faculty_id = fields.Many2one('Faculty', related='departement.faculty_id', store=True, index=True)

Then upgrade the module and log in again.

An alternative solution is, change the record rule as follows:


<record model="ir.rule" id="inscription_admin_rule">
  <field name="name">User inscription</field>
  <field name="model_id" ref="model_inscription"/>
  <field name="groups" eval="[(4, ref('tutorat.group_admin'))]"/>
  <field name="domain_force">[('departement.faculty_id', 'in', user.faculty_id.ids)]</field>

</record>


Hope it helps

Avatar
Discard
Avatar
DTech (pvt) ltd, Abhishek Bandaranayaka
Best Answer

Your rule is not working because faculty_id on inscription is a related field and (most likely) not stored in the database.

Record rules are evaluated at the SQL level. If the field used in domain_force is not stored (store=False), the rule will not behave correctly when adding or removing faculties on res.users.

In your case:

faculty_id = fields.Many2one(
    'faculty',
    string='Faculté',
    related='departement.faculty_id'
)

By default, related fields are not stored.

Solution

Make the related field stored:

faculty_id = fields.Many2one(
    'faculty',
    string='Faculté',
    related='departement.faculty_id',
    store=True
)

Then:

  1. Upgrade your module

  2. Restart Odoo

  3. Recompute existing records (if needed)

Why this fixes it

Your rule:

<field name="domain_force">
    [('faculty_id', 'in', user.faculty_id.ids)]
</field>

Now works correctly because:

  • inscription.faculty_id is stored in the database

  • The rule can filter records properly at SQL level

  • Changes in user.faculty_id are immediately reflected in access control

After adding store=True, the rule should work correctly when adding or removing faculties from users.

Avatar
Discard
Related Posts Replies Views Activity
Add menuitem to portal group
security xml groups odoo
Avatar
Avatar
Avatar
2
Oct 22
8409
Problemas al imprimir factura en el odoo
xml odoo
Avatar
0
Jan 25
3160
How to post xml code
xml odoo
Avatar
1
Mar 25
652
How to make field readonly to selected groups Solved
xml groups
Avatar
Avatar
2
Mar 24
9396
How can I include my generic qweb view on my Odoo 16 Form View using JS or Controller
xml odoo
Avatar
Avatar
1
Sep 23
4640