Bỏ qua để đến Nội dung
Câu hỏi này đã bị gắn cờ
many2manysyntaxrelation
1 Trả lời
19933 Lượt xem
Ảnh đại diện
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

  1. class res_partner(osv.osv, format_address):

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

.......
           }

  2. 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

Ảnh đại diện
Huỷ bỏ
Ảnh đại diện
Hiral Patel (hip)
Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ
omprakash
Tác giả

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!

Bài viết liên quan Trả lời Lượt xem Hoạt động
How can i have Reverse relation for many2many field in version 7.0?
many2many relation reverse
Ảnh đại diện
2
thg 9 15
6951
ODOO V16 Associate Parts to a Finished Good
many2many
Ảnh đại diện
Ảnh đại diện
1
thg 2 24
2026
Custom Model Data in Many2many field without storing in Database
many2many
Ảnh đại diện
0
thg 7 24
3097
ID for many2many relation is not exist
id many2many exists not relation
Ảnh đại diện
0
thg 2 23
2044
Why a new record is creating when selecting in Many2Many field
many2many
Ảnh đại diện
0
thg 7 22
60