Skip to Content
This question has been flagged
one2many
5 Replies
21821 डेटा देखने का तरीका
अवतार
Andres Fontenele

I wanna create a Model "PU" to optionally record details (many) of each record (one) of Model "TIN". How do I use the ORM to trigger the deletion of the records on Model "PU" when the reference to it on Model "TIN" is deleted?


अवतार
खारिज करें
अवतार
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

Take the case of the sale order and sale order line, if you are looking to delete the order lines while deleting the sale order, you can use ondelete='cascade'

See, In the sale order line,

order_id = fields.Many2one('sale.order', string='Order Reference', required=True, ondelete='cascade', index=True, copy=False, readonly=True)


ON DELETE CASCADE referential action for a foreign key that allows you to delete data from child tables automatically when you delete the data from the parent table.


Thanks

अवतार
खारिज करें
अवतार
Ankit H Gandhi(AHG)
Best Answer

Hello Andres Fontenele,

For your case need to connect with database from "UI" or "Terminal" then execute delete query of child relation table

Hope this help you

Best Thanks,

Ankit H Gandhi.

 

अवतार
खारिज करें
अवतार
Andres Fontenele
लेखक Best Answer

Thank you for your answer, Niyas.

I know about ondelete='cascade'. Sorry if I wasn't clear enough on my question. What I really want to know is how to delete the records when relation is lost. In your example it would be deleting the order.lines when these records aren't related to any sale.order.

Thanks.

अवतार
खारिज करें
Niyas Raphy (Walnut Software Solutions)

I think i haven't given the solution for what you have asked, with the reference lost means..., can you explain with a small example, so that it will be easy for me to understand

Andres Fontenele
लेखक

Pretty straight forward:

Parent Model A has these fields:

ID, DESC, QUANTITY, QUANTITY_DETAILS(ONE2MANY)

Child Model B has these fields:

ID, MODEL_A_ID (MANY2ONE), DETAIL1, DETAIL2

By setting the ondelete="cascade" on MODEL_A_ID field, the record on MODEL B will be deleted if the related MODEL A record is deleted, and that is clear.

The question is, assuming that there isn't a constraint preventing me to delete the content of the MODEL_A_ID field, if I set it to NULL it means that it has lost its relation to the parent MODEL A.

So the question is how to automatically delete this record on MODEL B, if it loses the relation in the way I have described above.

Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
how pass value to on2many field from parent form via context
one2many
अवतार
अवतार
1
जन॰ 25
4298
How to make tree view place last entered field on the top of tree view? What is the difference between editable="top" and editable="bottom"?
one2many
अवतार
अवतार
अवतार
2
सित॰ 22
11647
How to configure one2many field inside a form with domain or filter Solved
one2many
अवतार
अवतार
2
अप्रैल 22
6669
I got "ValueError: Invalid field 'Title' on model 'res.partner'" when I use One2many
one2many
अवतार
0
जुल॰ 21
9521
How to read the one2many field values on create method ?
one2many
अवतार
अवतार
1
मार्च 21
6876