Skip to Content
Menu
This question has been flagged
1 Atsakyti
2301 Rodiniai

Hi,

How to have a unique integer (  if we wante to add the same integer it should give us an error that this integer is already exist.

(usiing odoo 10)

Regards,

Portretas
Atmesti
Best Answer

Hello,

You can use sql constrains for it. In your py file add:

_sql_constraints = [
('your_field_unique',
'UNIQUE(your_field)',
"Warning Message"),
]


Portretas
Atmesti
Autorius

Sorry but it didn't work

Hi medmars,

Test it in the new db, it will work fine

Autorius

Hi Niyas,

It's work perfectly when creating new database is there any method to add it on exisitng database

Thanks