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 | etc.
I need to add sql constraint so that it prevent the duplication in customer name.The sql constraint cannot be added to the existing module as it cannot be edited.So a new module has to be created.How to create this module and how to inherit the features in my new module and add the new features. ?
You can add the following code in your module to apply unique constraint for Customer :
class res_partner(osv.osv): _inherit = 'res.partner' _sql_constraints = [ ('name_uniq', 'unique(name)', 'Customer Name must be unique!'), ]
Before installing the module, make sure that existing customers don't have duplicate names. If exists, rename those Customers, else constraints will not be applied.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 4/23/14, 9:43 AM|
|Seen: 1475 times|
|Last updated: 3/16/15, 8:10 AM|