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

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
Discard
Author

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

Best Answer

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
Discard
Author Best Answer

Thanks for your help. 


It's working as  expected.

Avatar
Discard
Author

Please help me ~~~

Related Posts Replies Views Activity
0
Jun 21
2190
1
Nov 20
4035
2
Jun 20
2702
2
Mar 24
4951
1
Jul 23
1200