Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
3 Replies
12217 Tampilan

Hello,

how can we apply sql unique constraint on a Many2one field in .line portion of a form.


_sql_constraints = [
('name_uniq', 'UNIQUE (subject)', 'You can not have two users with the same name !')
]
I wrote this but it is not working for me.
please help.
Avatar
Buang

_sql_constraints = [('name_of_field_unique', 'unique(name_of_field)',

'Error Message')]

is subject your many2one field?

yes..Many2one field



Mailtrack Sender notified by
Mailtrack 26/11/19, 11:20:07

On Tue, 26 Nov 2019 at 11:17, shalin wilson <shalinwilson1994@gmail.com> wrote:

_sql_constraints = [('name_of_field_unique', 'unique(name_of_field)',

'Error Message')]

is subject your many2one field?

Sent by Odoo S.A. using Odoo.

how to set unique constraint on field using api

Jawaban Terbai

Hi,

add the constraints in the many2one fields model

Avatar
Buang