跳至內容
選單
此問題已被標幟
2 回覆
4756 瀏覽次數

I have a fields.Char attribute “identification_id”, That field must have  11 characters. How can I add a _sql_constraints to check the length of that field and ensure it should be 11 ?

頭像
捨棄
最佳答案

_sql_constraints = [
        (
            'identification_id_len_check',
            'check (LENGTH(identification_id) = 11)',
            ('identification_id should be 11 symbols')
        ),
    ]
SQL constraints are faster in comparison to api.constrains. 
Make sure that none of your existing records have different size. Otherwise, constrain would not be created


頭像
捨棄
最佳答案

Hi,

If it is not mandatory to for _sql_constraints, try to achieve the same using the constrains.

@api.constrains('identification_id')
def check_identification_id(self):
for rec in self:
if len(rec.identification_id) != 11:
raise ValidationError(_('Must be 11 Characters'))


See : How To Add Constrains For A Field in Odoo12


Thanks

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
0
12月 24
1421
1
3月 24
2456
2
12月 23
3458
1
6月 23
12463
0
1月 23
3154