Skip to Content
मेन्यू
This question has been flagged
3 Replies
548 Views

Hello Odooers, 

Using Odoo Studio, I'm trying to find how I can make a unique field with an error message (ex. This Order ID already exists). 

I see some posts with the code below, but I have no idea where to insert it ? and if that's only a python code that cannot be used in Studio ?


_sql_constraints = [

        ('name_uniq', 'unique (name)', "Tag already exists!"),

    ]


Thanks for the help !

Much appreciate.

Avatar
Discard
Author Best Answer

Thank you both. I will test it right away.

Avatar
Discard
Best Answer

Hi,

You can add SQL constraints using a server action.


Example:

Steps:

1. Settings- > Technical -> Actions -> Server Action




Model: Sales Order

Type: Execute Code

Code:

env.cr.execute("""

    ALTER TABLE sale_order

    ADD CONSTRAINT unique_name UNIQUE (name)

""")


- unique_name = name of the constraint

- name = field


Hope it helps.



Avatar
Discard
Best Answer

The answer you've commented on in https://www.odoo.com/forum/1/155133 already says what to do if you can't do it with a module - i.e. Odoo Online. You need to create an Automation Rule that is triggered On Update and On Create to check if other records with that value already exist. You can not use the Studio UI directly if this is what you're asking explicitly.

_sql_constraints = [] is python code you can not add directly.

Automation Rules are created, when in Developer Mode (https://www.odoo.com/documentation/18.0/applications/general/developer_mode.html), via Settings -> Technical --> Automation -> Automation Rules.

Avatar
Discard
Related Posts Replies Views Activity
1
अक्तू॰ 22
3216
2
सित॰ 21
3658
2
अग॰ 25
3126
2
फ़र॰ 25
6405
3
सित॰ 24
46914