Odoo Help


One to many field access

Umashankar Subramani
on 1/9/15, 1:08 AM 843 views


    Can anyone suggest me how to access the one to many field and many to many field....... Thanks in advace

Nishant Jogi
On 1/9/15, 1:32 AM

Hello Umashankar,

You can do it with browse method and for loop combination.


Suppose you have 2 fields as below:

invoice_ids : fields.many2many('sale.order', 'res_sale_inv', 'sale_id', 'inv_id', 'Invoices')

line_ids : fields.one2many('sale.order.line', 'order_id', 'Order Ref')

You can access as per following code:

for rec in self.browse(cr, uid, ids, context=context):

for m_rec in rec.invoice_ids:

print "Name", m_rec.name

for o_rec in rec.line_ids:

print "Name", o_rec.name

Hope this will helps you.


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 1/9/15, 1:08 AM
Seen: 843 times
Last updated: 3/16/15, 8:10 AM