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

Related Posts	Відповіді	Переглядів
Is there a way to pass extra value to context from xmlrpc client ? orm xmlrpc	0 вер. 17	7127
how to format value for a many2many field thru XML RPC Вирішено xmlrpc many2many perl	4 жовт. 17	29277
Create product using XMLRPC - PHP, issue with public_categ_ids php xmlrpc many2many	2 черв. 16	12072
Creating model data with many2many field doesn't work Вирішено orm many2many controller	1 черв. 15	19490
OpenERP function field xmlrpc vals orm xmlrpc context	0 бер. 15	5072

Це запитання позначене

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