Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
10637 Lượt xem

How to Unique constraint a field in custom model on Odoo Enterprise 12.0 Online?

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hi Tameem,

I think you are trying to make the Unique field.

Usually, this is handled by SQL Constraints. In your case, you are using Odoo Online. So we must think differently to make it possible.

Anyway

Try this way. Maybe you will get the result you wish.

  1. Create an Automated action with the following parameters.

    • Model: your custom model

    • Trigger Condition: On Update

    • Action To Do: Execute Python Code

    • In the python code, try this code

new_value = record.YourFieldName
existing_records = env['Your.Model'].search([('YourFieldName', '=', new_value)])
if len(existing_records) > 1:
    raise Warning('Field value must be unique')


Thanks

Ảnh đại diện
Huỷ bỏ
Tác giả

Dear Avinash,

Your answer worked perfectly!

Thank you for your reply.

My pleasure

Hello, do you know if we can manage to do the same using Studio ?

Câu trả lời hay nhất

Hello, Avinash's answer works for me too but instead of having the warning I setted I have an Odoo error about the automated action itself. Do you know how to solve this ?

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 11 24
1389
2
thg 1 24
4698
3
thg 7 25
545
2
thg 7 25
3857
2
thg 9 21
4857