Skip ke Konten
Pertanyaan ini telah diberikan tanda
xmlrulesgroupsodoo
2 Replies
3374 Tampilan
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
Buang
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Jawaban Terbai

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
Buang
Avatar
DTech (pvt) ltd, Abhishek Bandaranayaka
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
Add menuitem to portal group
security xml groups odoo
Avatar
Avatar
Avatar
2
Okt 22
8424
Problemas al imprimir factura en el odoo
xml odoo
Avatar
0
Jan 25
3175
How to post xml code
xml odoo
Avatar
1
Mar 25
652
How to make field readonly to selected groups Diselesaikan
xml groups
Avatar
Avatar
2
Mar 24
9403
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
4659