Skip to Content
This question has been flagged
constraintuniquestudiov15
2 Respostes
6097 Vistes
Avatar
Caribbean Data Challengers

I need a new field in res.partner for account number. The number should only belong to one contact and must be created manually (no sequencing). How do we get a uniqueness check on that field to prevent duplicate entries and warn the user that the value already exists?

Avatar
Descartar
Avatar
Melanie Turleque
Best Answer

Hello, would you by any chance know the python code to use ?

Thanks a lot.

Avatar
Descartar
Vikas Jadav

Hi,

You can use sql constraints.
_sql_constraints = [('name_uniq', "unique(name, applicability, country_id)", "A tag with the same name and applicability already exists in this country.")]

Avatar
Niyas Walnut
Best Answer

Hi,

You can create an automated action in the database, that is getting triggered on writing or creating record in this model and you can raise warning if duplicates are found.


Check whether base_automation module is installed in the database, if not install it, then keeping the developer mode activated, navigate to Automated Actions menu under the settings and create a new record here, select triggered on Create & Update and execute a python code, that check and raises the warning.

Thanks

Avatar
Descartar
Related Posts Respostes Vistes Activitat
unique constraint on 2 fields one of them is many2many Solved
constraint unique many2many v15
Avatar
1
de febr. 22
4579
Restrict Studio ,to users Solved
studio v15
Avatar
Avatar
1
de des. 24
3713
Odoo Studio - V15 - Create new field in Contact Module.
studio v15
Avatar
0
de des. 21
3081
How can i add Unique constriant to field in openerp? Solved
constraint unique
Avatar
Avatar
Avatar
Avatar
Avatar
4
de març 15
13134
Raise Warning
warning studio v15
Avatar
Avatar
Avatar
2
d’ag. 24
16703