unique constraint on 2 fields one of them is many2many

Question

Hello,
i have 2 fields (partner_id, ref_ids(many2many)) i want to make sure that not a single ref_id can be repeated for each customer:
partner "test" ref "ref1"
partner "test2" ref "ref1" (ok)
partner
"test" ref "ref1" (not accepted)

any help would be appreciated

Ali Mahmoud · Accepted Answer

@api.constrains('ref_ids', 'partner_id')
def _check_ref(self):
for record in self:
for ref in record.ref_ids.ids:
bill = self.env['account.move'].search(
[('ref_ids', 'in', ref), ('partner_id', '=', self.partner_id.id)])
if len(bill) > 1:
raise ValidationError(_("You can't create 2 bills with the same vendor and reference"))

相关帖文	回复	查看
How can we add a unique field using Studio? constraint unique studio v15	2 8月 25	3573
many2many restrict selection [odoo15] many2many v15	0 9月 22	1937
how to use special comand for manymany fields many2many v15	1 7月 22	2219
unicity constraint on a many2many field in openerp constraint many2many	1 8月 15	8193
How can i add Unique constriant to field in openerp? 已解决 constraint unique	4 3月 15	12064

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！