many2many relation syntax

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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

many2many relation syntax

many2many syntax relation

1 Odpowiedz

20014 Widoki

omprakash

Hi Friends ,

I like to know about Fields Type / Relation Fields - many2many syntax

From the existing code : server/openerp/addons/base/res/res_partner.py

class res_partner(osv.osv, format_address):

_columns= {
         ..............
          'category_id': fields.many2many('res.partner.category', id1='partner_id', id2='category_id', string='category'),

.......
           }

class res_partner_category(osv.osv):

_columns={ ............
```
          'partner_ids': fields.many2many('res.partner', id1='category_id', id2='partner_id', string='Partners'),
        }
```
Actually my doubt is from the syntax i can't understand id1 & id2 . Please explain me .

Thanks & Regards

OMPRAKASH.A

Hiral Patel (hip)

id1 is actual.object.id and id2 is other.object.id. Actual object.id and other.object.id are the fields' names used in the relation table, and 'res.partner.category' is the relational object.

The syntax of M2M is fields.many2many('other.object.name', 'relation object', 'actual.object.id', 'other.object.id', 'Field Name')

*'other.object.name' is optional for v7.

Thank you

omprakash

Autor

Hi Hiral Patel , Thanks for immediate reply .. I have doubt in < id1 is actual.object.id and id2 is other.object.id. Actual object.id and other.object.id are the fields' names used in the relation table, > from this point what is relation table from this example & where i can find it ?

Gregor Huyskens

You can find this in the 6.0 documentation. The second argument is the relation name (and table name). https://doc.openerp.com/v6.0/developer/2_5_Objects_Fields_Methods/field_type.html/ ... fields.many2many('other.object.name', 'relation object', ... Where: relation object is the table that makes the link (...) Example: 'category_ids': fields.many2many( 'res.partner.category', 'res_partner_category_rel', 'partner_id', 'category_id', 'Categories'),

evon_dun

I want to use partner's name from 'partner_ids' field which is a 'many2many' field in the 'partner.ledger.webkit' model, in the attachment prefix for the report 'Partner Ledger Report' example 'object.company_id.name.pdf'. Please help!

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How can i have Reverse relation for many2many field in version 7.0? many2many relation reverse	2 wrz 15	7040
ODOO V16 Associate Parts to a Finished Good many2many	1 lut 24	2178
Custom Model Data in Many2many field without storing in Database many2many	0 lip 24	3243
ID for many2many relation is not exist id many2many exists not relation	0 lut 23	2104
Why a new record is creating when selecting in Many2Many field many2many	0 lip 22	60

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!