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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
5803
Views
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!")
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
5
Oct 24
|
28476 | ||
|
1
Jul 23
|
4400 | ||
|
2
Jul 22
|
9128 | ||
|
2
Oct 21
|
1945 | ||
|
0
Aug 21
|
1179 |
