Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
xmlrulesgroupsodoo
2 Odgovori
3284 Prikazi
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
Opusti
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
Opusti
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
Opusti
Related Posts Odgovori Prikazi Aktivnost
Add menuitem to portal group
security xml groups odoo
Avatar
Avatar
Avatar
2
okt. 22
8359
Problemas al imprimir factura en el odoo
xml odoo
Avatar
0
jan. 25
3081
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
9358
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
4565