Odoo Help


delete one2may records when parent record is deleted

Shaumyadeep Chaudhuri
on 9/12/13, 6:07 AM 10,133 views

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?

On 9/12/13, 6:42 AM

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)]}),

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)]}),

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

Shaumyadeep Chaudhuri
on 9/12/13, 10:18 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/12/13, 6:07 AM
Seen: 10133 times
Last updated: 3/23/16, 7:28 AM