Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi everyone, I'd like to constraint contact/company with same name,
I added this lines of code to /odoo/models.py , /odoo/addons/base/models/res_partner.py
_sql_constraints = [('name_uniq', 'unique (name)', 'The company name must be unique !'),
('email_uniq', 'unique(email)', ' Please enter Unique email no.')] #: SQL constraints [(name, sql_def, message)]
a restart odoo in windows and in linux aswell, but constraint doesn't work,
in what file I have to add this lines?
thank you Niyas, I upgraded the base module in App>Contacts>(3 point menu)>upgrade but it doesn't make any difference, also I did not see any duplicates in res_partners table.
could you tell me from what path I edit file module from the UI?
Have you a guide on how to develop custom module?
thank you so much I'm going crazy :)
For adding constrains from ui, see: https://www.youtube.com/watch?v=H4IJnNqlBq0
From custom module, see: https://www.youtube.com/watch?v=ijS-N1CdiWU&list=PLqRRLx0cl0hoJhjFWkFYowveq2Zn55dhM&index=16
Hi,
Did you upgrade the base module after adding the constrains ? If not upgrade the module and see whether it makes any difference.
Also the sql constrains will not work, if there is already duplicated names in the database.
NB: also it is not recommended to edit the original odoo source code, instead do it using a custom module or from user interface.
Thanks
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
