How to find out the table name for a many2many relation (Where is the many2many table name stored?)

Question

Hi,
I am trying to recover data from a broken odoo installation (uprade got screwed up).
I have exported all the tables to CSV using postgresql (psql). I would also be able to handle many2one and one2many relations.
For many2many relations, I need a way to programatically find out which database table contains the relation details (ids from both the models). I tried to get the data from the ORM "fields_get" function using xmlrpc. The  field definition returns a dictionary which has a key named '

Pawan · Accepted Answer

Hi,

You can get the name of the relation table by seeing the fields definition only. Or, odoo maintains a separate table called 'ir_model_relation' containing the module id(like, Project) and the object(model) id(like project_project ) with relation tables name for that object, you can use this table to get all the relation for that particular model(object) .
Thanks

Abdelhalim KADDOUR GUETTAOUI · Answer

i want to explain how odoo framework create related table for many2many for exemple we have your  model1  where you created "category_id" and the other  model2  where you Create the relation with many2many
Now for each models odoo create table in Psql , so for models1 odoo create in Psql  table:model1 and for the second model Psql create  table: Model2  and for the relation many2many Psql create the third his name is  table:model1_Model2
so in odoo create this table with  underscore  and the 2 t

Matt Horne · Answer

In Odoo 9, you can query ir_model_fields to get the table name from the relation_table column.
I'm not too sure about 7 and 8, but I think in 6.1 you could check the field definition from a fields get - something like:
self.fields_get(cr, uid, ['my_m2m_field'])['my_m2m_field']['third_table']

Stuti Mehta · Answer

Go to settings and from technical menu there is many2many option from where you can fetch all the many2many tables of your project

المنشورات ذات الصلة	الردود	أدوات العرض
Is there a way to pass extra value to context from xmlrpc client ? orm xmlrpc	0 سبتمبر 17	7124
how to format value for a many2many field thru XML RPC تم الحل xmlrpc many2many perl	4 أكتوبر 17	29276
Create product using XMLRPC - PHP, issue with public_categ_ids php xmlrpc many2many	2 يونيو 16	12057
Creating model data with many2many field doesn't work تم الحل orm many2many controller	1 يونيو 15	19485
OpenERP function field xmlrpc vals orm xmlrpc context	0 مارس 15	5071

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!