Deleting boms does not delete subproducts (Byproduct Module)

[Paul Catinean]

The summary if pretty self explanatory

I install mrp_byproduct

Create a product

Create a bom with byproduct using the previously created product

Delete bom and product cannot be deleted because mrp.subproduct still references it and select * from mrp_subproduct reveals results when all boms are deleted...is this normal behaviour?

[Twinkle Christian(OpenERP) (tch-openerp)]

Hello,

I think you have misunderstood something, I have attached my brief tested screen cast, which will clarify your issue.

Hope this will helpful to you.

Thanks,

[Paul Catinean (wiz-keed)]

Hello Christian and thank you very much for taking interest in this topic

I saw the video, the only thing missing was to set inside the bom a byproduct in the Byproducts tab and then delete the whole bom, since byproducts are kept in a separate table

Try the same example only this time setting the same product or some other product in the byproducts tab

If it works again then I'm wrong

Kind regards,

Paul

[Amit Parik (amit-parik)]

Hello Paul,

Yes, You are correct!. I have tested the same and issue data still linked on database

We can't seen its simply but we have to checked it via potgres, please select id from mrp_subproduct; It's still gives the result aftre delete the bom.

Thank you!

[Amit Parik (amit-parik)]

We need to override the unlink method of mrp_bom for resolve it.

Thank you!

[Paul Catinean (wiz-keed)]

Very happy to help Amit!

[Paul Catinean (wiz-keed)]

Amit, one last thought: Instead of updating the unlink method wouldn't it be better/safer to just set cascade delete so it automatically happens and there's also a sql constraint to it?

[Amit Parik (amit-parik)]

Hello Paul,

Thanks for the response!

I agreed with you, we can use the ondelete="cascade" that will be usable.

Thanks for the notification!