Skip to Content
Menu
This question has been flagged
2 Replies
1262 Views

Hello, Odoo community,


I'm relatively new to Odoo and would appreciate some guidance on an issue I'm facing with Record Rules. I've been working on restricting access to specific records using Record Rules, and it seems to work well when I apply a filter for a single ID like this: [('id', '!=', 1839)].


However, I've encountered difficulties when attempting to expand this to include multiple IDs in the filter. I've tried the following variations without success:

1. ['&', ('id', '!=', 1839), ('id', '!=', 1789)]

2. ['|', ('id', '!=', 1839), ('id', '!=', 1789)]


Despite these attempts, the records are not being filtered as expected. If anyone has experience with setting up Record Rules to restrict access based on multiple IDs, I would greatly appreciate your insights. Thank you for your help!

Avatar
Discard
Author Best Answer

Hey Karan, 

it worked appreciate you.

Fares

Avatar
Discard
Best Answer

Hello Fares,

Use [('id', 'not in', [1839, 1789)] instead. It's better to use not in operator for excluding multiple records. 


Regards,

Karan BK

Avatar
Discard
Related Posts Replies Views Activity
2
Jan 24
2927
0
Jan 24
1384
1
Sep 23
1136
1
Nov 21
4308
0
May 21
2511