İçereği Atla
Menü
Bu soru işaretlendi
2 Cevaplar
3951 Görünümler

Create @api.constrains to check: 

_sql_constraints = [
        (
            "phone_owner_uniq",
            "unique (phone, owner)",
            "You cannot have two tenants with the same phone number for the same owner!",
        )
    ]

This is sql.contrains but I want to check with python constrains.

Please help me ...

Avatar
Vazgeç
Üretici

@Kiran K
In odoo, it's working.
But in my app (FE: React native), It show error message, but it still create.
Is there any way to fix it?

En İyi Yanıt

Hi BB,

Try,

    @api.constrains('phone', 'owner')

    def check_phone_owner_uniq(self):

        for record in self:

            duplicate_records = self.search([

                ('phone', '=', record.phone),

                ('owner', '=', record.owner.id),

                ('id', '!=', record.id)

            ])

            if duplicate_records:

                raise ValidationError("You cannot have two tenants with the same phone number for the same owner!")

Avatar
Vazgeç
Üretici En İyi Yanıt

Thanks for your help. 


It's working as  expected.

Avatar
Vazgeç
Üretici

Please help me ~~~

İlgili Gönderiler Cevaplar Görünümler Aktivite
0
Haz 21
3043
1
Kas 20
4857
2
Haz 20
3609
2
Mar 24
6209
1
Tem 23
2095