Custom model - avoid deleting values when in use

Question

Our product DB is a list of comics. We made a custom model for the publishers of these comics. A custom field in the product detail view has been made to add (or create) a publisher to a comic. When created in the product detail view, the new publisher correctly appears in the publishers' list (for which we created an extra menu). However, we are able to delete entries (or values) in this list, even when they are in use in a product. How can we avoid deleting values from this model when they are

Waleed Mohsen (CorTex IT Solutions) · Accepted Answer

You have used the Many2one field to link the product with publisher so you can add the below attribute to that field
ondelete='restrict' For example:
publisher_id = fields.Many2one('publisher', required=True, ondelete="restrict")     Reference:

ORM API — Odoo 15.0 documentation [1]

[1] https://www.odoo.com/documentation/15.0/developer/reference/backend/orm.html#relational-fields

Bart Pinceel · Answer

Thnx.
I'm fairly new to Odoo. I created this model from the backend (Odoo 15 enterprise). Where would I have to write this line of code (or similar)?

İlgili Gönderiler	Cevaplar	Görünümler
Loop through custom model and show records on frontend website or e-commerce on Odoo16 custom model theme	0 Kas 22	2172
What's the difference between sale_order and sale_order_line? Çözüldü model	3 Kas 24	29948
How can I mark a field "unique" in a custom model? Çözüldü field custom unique model	3 Eyl 24	46886
Self hosting Odoo custom Çözüldü custom	1 Ağu 24	1811
add custom field in res.users - showing validation error fields custom model odoo16features	1 Eyl 23	3236

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!