コンテンツへスキップ
メニュー
この質問にフラグが付けられました
2 返信
3996 ビュー

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
3052
1
11月 20
4898
2
6月 20
3626
2
3月 24
6248
1
7月 23
2140