how to make a field unique with combination of two fields in the same table

Question

I want to make a field Unique with combination of two fields and it does not show on form

class shipment_charge(osv.osv):
_name = 'shipment.charge'
_columns = {
'type': fields.selection(list_type, 'Type', required=True, ),
'mode': fields.selection(list_mode, 'Mode', required=True, help=""),
'transit_time': fields.selection(list_transit_time, 'Transit Time', required=True, help=""),
'charges_key': fields.char('charges_key', size=64, help=""),
}
_sql_constraints = [
('charges_key_unique', 'unique

Ashif Abdulrahman · Accepted Answer

use this

def check_existance(self, cr, uid, ids, context=None):
self_obj = self.browse(cr, uid, ids[0], context=context)
field1 = self_obj.field1
field2 = self_obj.field2
search_ids = self.search(cr, uid, [('field1', '=', field1),('field2', '=' , field2)], context=context)
res = True
if len(search_ids) > 1:
res = False
return res

and add

_constraints = [(check_existance,'Combination already exist', ['field1'])]

Abhishek H Menon · Answer

_sql_constraints = [
('name_uniq', 'unique(type, mode)', 'The Charges Key is not Unique!'),
]

Please replace this instead of that

Thomas Guénard · Answer

Below the code of a server action which concatenet 2 or more field into a new one

Bài viết liên quan	Trả lời	Lượt xem
It is possible to have duplicate serial numbers for a product across warehouses [?] unique serial_numbers	4 thg 6 24	7768
Can I enforce unique (Refence code) Internal Reference for Products? Đã xử lý unique duplicates	2 thg 12 23	3448
How can i add Unique constriant to field in openerp? Đã xử lý constraint unique	4 thg 3 15	12961
Product Default Code Unique (product_unique_default_code) not working? product unique	2 thg 3 15	9797
generating reference number unique warranty	1 thg 3 15	9233

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!