Skip to Content
This question has been flagged
xmlrulesgroupsodoo
2 Replies
3268 Rodiniai
Portretas
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é')





Portretas
Atmesti
Portretas
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

Portretas
Atmesti
Portretas
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.

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Add menuitem to portal group
security xml groups odoo
Portretas
Portretas
Portretas
2
spal. 22
8345
Problemas al imprimir factura en el odoo
xml odoo
Portretas
0
saus. 25
3053
How to post xml code
xml odoo
Portretas
1
kov. 25
652
How to make field readonly to selected groups Solved
xml groups
Portretas
Portretas
2
kov. 24
9342
How can I include my generic qweb view on my Odoo 16 Form View using JS or Controller
xml odoo
Portretas
Portretas
1
rugs. 23
4548