Skip to Content
Меню
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
Це запитання позначене
2 Відповіді
3925 Переглядів

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?


Аватар
Відмінити
Найкраща відповідь

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

Аватар
Відмінити
Найкраща відповідь

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

Аватар
Відмінити
Автор

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 Відповіді Переглядів Дія
2
вер. 24
2303
1
серп. 23
2095
1
трав. 23
3485
0
січ. 18
2763
3
серп. 25
2263