Help

3

delete one2may records when parent record is deleted

Avatar
Shaumyadeep Chaudhuri

Hi, I want to delete the records in the one2many fields when the original record that had them is deleted. I tried adding ondelete="cascade" to the one2many declaration but the records in the one2many table still remains when i delete the record holding it. How do i achieve this?

Avatar
Discard
1 Answer
7
Avatar
saad
Best Answer

Hi,
You should put ondelete="cascade" in the field relation id like here:

class sale_order(osv.osv):
    _name = 'sale.order'
    _columns = {
        'name': fields.char('Order Reference', size=64, required=True, readonly=True, states={'draft': [('readonly', False)], 'sent': [('readonly', False)]}, select=True),
        'order_line': fields.one2many('sale.order.line', 'order_id', 'Order Lines', readonly=True, states={'draft': [('readonly', False)], 'sent': [('readonly', False)]}),
        ....
sale_order()


class sale_order_line(osv.osv):
     _name = 'sale.order.line'
     _columns = {
        'order_id': fields.many2one('sale.order', 'Order Reference', required=True, ondelete='cascade', select=True, readonly=True, states={'draft':[('readonly',False)]}),
        .
        .
        .
sale_order_line()
1 Comment
Avatar
Discard
Avatar
Shaumyadeep Chaudhuri
-

Thanks, i was doing it the other way round. Now it solved the problem