Skip to Content
This question has been flagged
constraintmany2manyodoo8.0
1 Respondre
7415 Vistes
Avatar
Anti Nuga

I'm trying to check if a many2many field has 2 specific records in it and then a constraint to it. I first tried to check if it had one specific record in it:

from openerp import models, fields, api, exceptions
class Partnerlead(models.Model):
    _inherit = 'crm.lead'
    @api.constrains('categ_ids')
    def _check_tags(self):
        for record in self:
            if (12) in record.categ_ids:
                raise exceptions.ValidationError('Error')

And I get an error:

ValidateError
Error while validating constraint
ValueError
Mixing apples and oranges: 12 in crm.case.categ(3, 8)

How do you exactly check if my crm.lead record has crm.case.categ field id 12 in its categ_ids m2m field? If I know how to check for a record, I can check for many. Thanks for advance.

Avatar
Descartar
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi Anti,

You can do it using the following code,

class PartnerLead(models.Model):
    _inherit = 'crm.lead'

    @api.constrains('categ_ids')
    def _check_tags(self):
        for record in self:
            for rec in record.categ_ids:
                if rec.id == 12:
                    raise ValidationError(_("Error"))
Avatar
Descartar
Related Posts Respostes Vistes Activitat
unicity constraint on a many2many field in openerp
constraint many2many
Avatar
Avatar
1
d’ag. 15
8132
How to insert current date column in many2many relational table in odoo 8 ? Solved
many2many datetime odoo8.0
Avatar
Avatar
Avatar
3
d’ag. 20
9854
unique constraint on 2 fields one of them is many2many Solved
constraint unique many2many v15
Avatar
1
de febr. 22
3675
Cannot execute name_create, no _rec_name defined Solved
many2many name_search many2many_tags odoo8.0
Avatar
1
de gen. 22
10497
In odoo 8 Contracts Form Check Date constraints method gets triggered even after providing valid input dates. How to fix this?
constraint contracts odooV8 odoo8.0
Avatar
0
d’abr. 19
4324