Pular para o conteúdo
Menu
Esta pergunta foi sinalizada
1 Responder
3605 Visualizações

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
Cancelar
Melhor resposta

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
Cancelar
Autor

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.

Publicações relacionadas Respostas Visualizações Atividade
2
set. 24
2064
1
ago. 23
1835
1
mai. 23
3232
0
jan. 18
2680
1
mai. 25
2178