Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
2 Besvarelser
4057 Visninger

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
Kassér
Forfatter

@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?

Bedste svar

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
Kassér
Forfatter Bedste svar

Thanks for your help. 


It's working as  expected.

Avatar
Kassér
Forfatter

Please help me ~~~

Related Posts Besvarelser Visninger Aktivitet
0
jun. 21
3070
1
nov. 20
4914
2
jun. 20
3657
2
mar. 24
6297
1
jul. 23
2180