Skip to Content
Dette spørgsmål er blevet anmeldt
xmlrulesgroupsodoo
2 Besvarelser
3395 Visninger
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
Kassér
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Bedste svar

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
Kassér
Avatar
DTech (pvt) ltd, Abhishek Bandaranayaka
Bedste svar

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
Kassér
Relaterede indlæg Besvarelser Visninger Aktivitet
Add menuitem to portal group
security xml groups odoo
Avatar
Avatar
Avatar
2
okt. 22
8457
Problemas al imprimir factura en el odoo
xml odoo
Avatar
0
jan. 25
3200
How to post xml code
xml odoo
Avatar
1
mar. 25
652
How to make field readonly to selected groups Løst
xml groups
Avatar
Avatar
2
mar. 24
9423
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
4683