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

CRM
e-Commerce
Financeiro
Inventário
PoS
Projeto
MRP

All apps

Todas as publicações Pessoas Emblemas

Marcadores (Ver tudo)

odoo accounting v14 pos v15

Sobre este fórum

Ajuda

Get field value from another model

product field sale.order.line model v12

4 Respostas

17937 Visualizações

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 Melhor resposta

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 ?

Está gostando da discussão? Não fique apenas lendo, participe!

Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!

Publicações relacionadas	Respostas	Visualizações
Could you confirm that the field product_id in hr_employee model doesn't exist in Odoo 10? Resolvido product field employee model	3 jan. 17	3825
How to create a incremental custom field , that increase its value for each stockable product? product field sequence sale.order.line stockable	0 fev. 16	3650
How to create a incremental custom field , that increase its value for each product stockeable? product field sequence sale.order.line stockable	0 fev. 16	4343
what's the field '_date_name' means in a model field model	0 mar. 24	4265
Change Sale Quotation Form so Product is Not Required? product sale.order.line	2 mar. 18	4150

Esta pergunta foi sinalizada

Está gostando da discussão? Não fique apenas lendo, participe!