Check uniqueness of a field value with onchange event in edit(or draft) mode

Question

When the user is creating a new record in a model(for example creating a new contact) I want to check the uniqueness of a field value just at the moment the field is changed, not after finishing and saving the entire form.

Here is my sample code:
quotation_id = fields.Many2one(
​comodel_name="sale.order",
​string="Quotation ID",
​required=True,
​readonly=True
)
and this is my XML:  	 ​ 	 ​< field name="quotation_id"/>
I've defined a sql constraint as follow:
​_sql_constraints = [
​    ('quotati

Melanie Turleque · Answer

Is this only possible via Python code ? isn't that something we can define in Odoo Studio ?

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
You can use SQL Constraints that prevent incorrect data before saving the record. For example:-
barcode=fields.Char()
_sql_constraints = [('barcode_uniq', 'unique(barcode)', "A barcode can only be assigned to one product !")]
You can use the above code in your Python file.
for more reference:- https://www.cybrosys.com/blog/configuration-of-python-and-model-constraints-in-odoo-15 [1]
Regards

[1] https://www.cybrosys.com/blog/configuration-of-python-and-model-constraints-in-odoo-15

관련 게시물	답글	화면
adding multiple _sql_constraints? 해결 완료 model constraints odoo16features	2 9월 24	2340
multiple models in single .py file with constraints throwing error model constraints odoo16features	1 8월 23	2124
Problem with computed field constraint computed-fields odoo16features	1 5월 23	3568
Bug in Odoo 9 with constraints? error constraint bug constraints odoo9	0 1월 18	2814
How to Add wizard under print button inside the form view. odoo16features	3 8월 25	2452

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!