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

Powiązane posty	Odpowiedzi	Widoki
adding multiple _sql_constraints? Rozwiązane model constraints odoo16features	2 wrz 24	4411
multiple models in single .py file with constraints throwing error model constraints odoo16features	1 sie 23	4154
Problem with computed field constraint computed-fields odoo16features	1 maj 23	5975
Bug in Odoo 9 with constraints? error constraint bug constraints odoo9	0 sty 18	4429
DeprecationWarning: The longpolling-port is a deprecated alias to the gevent-port option, please use the latter Rozwiązane odoo16features	5 wrz 25	30122

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!