How to keep multiple Many2many fields on the same model Odoo Version 12

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

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

How to keep multiple Many2many fields on the same model Odoo Version 12

4 Replies

7913 Views

urgent odooV12

Ramla

class AnimaleSouche(models.Model):

_name = 'animale.souche'

_description ="Les souches des animaux"

name = fields.Char(string='Nom de la souche', required=True)

image = fields.Binary(string='Image')

description = fields.Char(string='Description')

programme_norme = fields.Many2many('animale.programme.norme', 'animale.souche', string='Programme de norme', ondelete='cascade', required=True)

programme_production = fields.Many2many('animale.programme.production', 'animale.souche', string='Programme de production', ondelete='cascade', required=True)

Mitul Shingala

you want many2many of same model or different model.

Ramla

Author

same model

Mitul Shingala

Hello

for given many2many of same model you have to pass the table/relationship table name into the definition of the field.

for eg

partner_ids1 = fields.Many2many('res.partner', 'relation_table_one', 'col1', 'col2', string="Line1")
partner_ids2 = fields.Many2many('res.partner', 'relation_table_two', 'col1', 'col2', 'string="Line2")

try like this, may this will helps you.

Ramla

Author

Hi,

programme_norme = fields.Many2many('animale.souche', 'animale.programme.norme', 'animale_souche_id', 'animale_programme_norme_id', string='Programme de norme')

programme_production = fields.Many2many('animale.souche', 'animale.programme.production', 'animale_souche_id', 'animale_programme_production_id', string='Programme de production')

Erreur:

Odoo Server Error

Traceback (most recent call last):

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 654, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 312, in _handle_exception

raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\pycompat.py", line 87, in reraise

raise value

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 696, in dispatch

result = self._call_function(**self.params)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 344, in _call_function

return checked_call(self.db, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\service\model.py", line 97, in wrapper

return f(dbname, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 337, in checked_call

result = self.endpoint(*a, **kw)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 939, in __call__

return self.method(*args, **kw)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 517, in response_wrap

response = f(*args, **kw)

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web\controllers\main.py", line 966, in call_button

action = self._call_kw(model, method, args, {})

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web\controllers\main.py", line 954, in _call_kw

return call_kw(request.env[model], method, args, kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 749, in call_kw

return _call_kw_multi(method, model, args, kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 736, in _call_kw_multi

result = method(recs, *args, **kwargs)

File "<decorator-gen-67>", line 2, in button_immediate_upgrade

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_module.py", line 73, in check_and_log

return method(self, *args, **kwargs)

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_module.py", line 614, in button_immediate_upgrade

return self._button_immediate_function(type(self).button_upgrade)

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_module.py", line 553, in _button_immediate_function

modules.registry.Registry.new(self._cr.dbname, update_module=True)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\registry.py", line 86, in new

odoo.modules.load_modules(registry._db, force_demo, status, update_module)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\loading.py", line 417, in load_modules

force, status, report, loaded_modules, update_module, models_to_check)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\loading.py", line 313, in load_marked_modules

perform_checks=perform_checks, models_to_check=models_to_check

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\loading.py", line 195, in load_module_graph

registry.init_models(cr, model_names, {'module': package.name})

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\registry.py", line 301, in init_models

func()

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 2629, in update_db_foreign_keys

sql.add_foreign_key(cr, self.relation, self.column2, comodel._table, 'id', 'cascade')

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\sql.py", line 158, in add_foreign_key

cr.execute(query.format(tablename1, columnname1, tablename2, columnname2, ondelete))

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 148, in wrapper

return f(self, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 225, in execute

res = self._obj.execute(query, params)

psycopg2.ProgrammingError: ERREUR: la relation « _unknown » n'existe pas

Mitul Shingala

programme_production = fields.Many2many('animale.souche', 'animale_programme_production', 'animale_souche_id', 'animale_programme_production_id', string='Programme de production')

give the relation name with underscore. and make sure that the name is not exist into the system. so give the name like "table_rel_animale_programme_production"

Ramla

Author

sorry, I'm not understand

Ramla

Author

can you give me an example

Mitul Shingala

see my above answer, i have make the text bold.

for make the many2many of same model you need to give the relationship table name. in example i have given like "relation_table_one".

Ramla

Author

programme_norme_ids = fields.Many2many('animale.programme.norme', 'animale_programme_norme_animale_souche_rel', 'animale_souche_id', 'animale_programme_norme_id', string='Programmes de norme')

programme_production_ids = fields.Many2many('animale.programme.production', 'animale_programme_production_animale_souche_rel', 'animale_souche_id', 'animale_programme_production_id', string='Programmes de production')

"programme_production_ids" works but "programme_norme_ids" no