Skip to Content
Menú
This question has been flagged
1 Respondre
6605 Vistes

hi all

i need to create unique python constraint (by convert this sql constraint) to be applied for all records
_sql_constraints = [
        ('unique_mobile', 'unique (mobile)', 'Mobile number already exists!')
    ]
Thanks

Avatar
Descartar
Autor Best Answer

i found a solution

# Mobile Field to be unique
@api.constrains('mobile')
def _check_mobile_unique(self):
mobile_counts = self.search_count([('mobile', '=', self.mobile), ('id', '!=', self.id)])
print(mobile_counts)
if mobile_counts > 0:
raise ValidationError("Mobile number already exists!")
Avatar
Descartar
Related Posts Respostes Vistes Activitat
5
d’oct. 24
32586
1
de jul. 23
7255
2
de jul. 22
11441
2
d’oct. 21
3239
0
d’ag. 21
2004