Skip to Content
Menu
Dette spørgsmål er blevet anmeldt

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 = [
​ ('quotation_id_uniq', 'UNIQUE (quotation_id)', 'This Quotation Number is asigned to a previous spot. Please choose another one.')
​]

The user can enter an ID in the field.
I want to check this field just as it changes and inform the user if ID is selected before.

How can I do that?


Avatar
Kassér
Bedste svar

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

Avatar
Kassér
Bedste svar

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

Regards

Avatar
Kassér
Forfatter

As I mentioned above the problem is that _sql_constraints doesn't check until saving occurs. I want to check the field at the moment it modifies.

Related Posts Besvarelser Visninger Aktivitet
2
sep. 24
2373
1
aug. 23
2151
1
maj 23
3589
0
jan. 18
2826
3
aug. 25
2475