Get field value from another model

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

Get field value from another model

product field sale.order.line model v12

4 Odpowiedzi

17162 Widoki

CAVAILLÈS

Hi,

I want to add product type in sale order lines but the field is on another model.

How can I get its value ?

Thanks in advance !

CAVAILLÈS

Autor Najlepsza odpowiedź

I put it here in case someone needs to do it as well.

Here is the final code :

class SaleOrder(models.Model):

_inherit = "sale.order"

class SaleOrderLine(models.Model):

_inherit = "sale.order.line"

product_type_id = fields.Selection(related='product_id.product_tmpl_id.type', string='Type')

I found it thanks to this link : https://www.odoo.com/fr_FR/forum/aide-1/question/odoo-10-how-to-set-a-product-category-field-to-the-sale-order-line-128344

Kiran K

When you need to show the value of a field from a relational model to the current model you can do that by defining a related field. To do that you need in the field definition to define attribute related with value sequence of field names.

class AccountInvoiceInherited(models.Model):

    _inherit = 'account.invoice'

    company_selection = fields.Many2one('account.analytic.account', string="Company")

class AccountMoveInherited(models.Model):

    _inherit = 'account.move'

    rel_account_invoice = fields.Many2one('account.invoice', string='Related Account Invoice')

    rel_company_selection = fields.Many2one('account.analytic.account', string="Company",          related='rel_account_invoice.company_selection')

CAVAILLÈS

Autor

OK, so I have this :

class SaleOrder(models.Model):

_inherit = "sale.order"

class ProductTemplate(models.Model):

_inherit = 'product.template'

class SaleOrderLine(models.Model):

_inherit = "sale.order.line"

type_id = fields.Many2one("product.template", string="Type")

rel_type_id = fields.Many2one("product.template.type", string="Type", related="type_id.type")

What am I missing ?

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
Could you confirm that the field product_id in hr_employee model doesn't exist in Odoo 10? Rozwiązane product field employee model	3 sty 17	3158
How to create a incremental custom field , that increase its value for each stockable product? product field sequence sale.order.line stockable	0 lut 16	3017
How to create a incremental custom field , that increase its value for each product stockeable? product field sequence sale.order.line stockable	0 lut 16	3651
what's the field '_date_name' means in a model field model	0 mar 24	3216
Change Sale Quotation Form so Product is Not Required? product sale.order.line	2 mar 18	3591

To pytanie dostało ostrzeżenie

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