Can I create a model out of the relation table in a many2many relationship?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Comptabilité
Inventaire
PoS
Project
MRP

All apps

Toutes les publications Personnes Badges

Étiquettes (Voir toutl)

odoo accounting v14 pos v15

À propos de ce forum

Aide

Can I create a model out of the relation table in a many2many relationship?

many2many model

1 Répondre

6555 Vues

jgonzalez

Hi, when creating a many2many relationship like in the following example.

'tag_ids': fields.many2many("task.tags", "task_tags_rel", "task_id", "tag_ids", string="Task Tags"),

The framework creates the relation table "task_tags_rel". As a result, I don't have any model for that particular table as I have for the rest of the others. I need to have some extra fields in the relation table "task_tags_rel" as a result of that relation allowing me to have a model I can create a view for. Can I create a model out of the relation table in a many2many relationship?

Thanks,

jgonzalez

Auteur

I found a work-around for what I wanted to do. Although I know a model can't be made out of the many2many relation table at present time I'd have liked to hear from someone going through the same experience. Thanks jgonzalez

Leonardo Donelli

Just create the model you need, and give it a one2many field for table A and one2many field for table B. Your model will then be your many2many link between table A and table B, if you want tou can even write some methods to get all Table B record ids given a Table A record id and viceversa.

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !

S'inscrire

Publications associées	Réponses	Vues
What's the difference between sale_order and sale_order_line? Résolu model	3 nov. 24	30265
ODOO V16 Associate Parts to a Finished Good many2many	1 févr. 24	2178
How can i set 'res_model' when saving 'ir.attachment'? attachment many2one many2many model	2 nov. 23	7231
Custom Model Data in Many2many field without storing in Database many2many	0 juil. 24	3243
Why a new record is creating when selecting in Many2Many field many2many	0 juil. 22	60

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !