跳至内容
菜单
此问题已终结
2 回复
3123 查看

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 ...

形象
丢弃
编写者

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

最佳答案

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!")

形象
丢弃
编写者 最佳答案

Thanks for your help. 


It's working as  expected.

形象
丢弃
编写者

Please help me ~~~

相关帖文 回复 查看 活动
0
6月 21
2573
1
11月 20
4376
2
6月 20
3106
2
3月 24
5525
1
7月 23
1555