Odoo (v11) Fetch data of one field from one model to another

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

Odoo (v11) Fetch data of one field from one model to another

3 Odpowiedzi

5032 Widoki

Abdullah

Hey! In stock.warehouse.orderpoint we have a field for minimum quantity. I want that field in my product.template model to. So that whatever minimum quantity is defined in the "Reorder rule" that value must be in the separate field in my form/tree view of product.template.

I am trying to use related field but it makes me select the record to fetch the value and i dont want that. Value must come by itself without any selection at all. Below are my related fields

re_order = fields.Many2one('stock.warehouse.orderpoint',string = 'Reorder', store=True)

min_qty = fields.Float(related='re_order.product_min_qty',string = 'Minimum Quantity', store=True)

Some help would be nice. Thanks in advance

Waleed Ali Mohsen

Do you want to modify it from product.template or just for viewing?

Abdullah

Autor

I just want to view that field in product template tree view for each product. Kindly help i'll be very thankful

Waleed Mohsen (CorTex IT Solutions)

Najlepsza odpowiedź

You can use computed field as below:

min_qty = fields.Float(compute='_get_min_qty', string='Minimum Quantity')

def _get_min_qty(self):
    for prod_tml in self:
        product = self.env['product.product'].search([('product_tmpl_id','=',prod_tml.id)])
        product_reorder = self.env['stock.warehouse.orderpoint'].search([('product_id','=',product.id)],limit=1)
        if product_reorder:
            prod_tml.min_qty= product_reorder.product_min_qty

Abdullah

Autor

Hey man Thank you so much, This worked like a char,. Just one question y i am not able to inherit and add this working field in tree view it is giving this error

" ValueError: Expected singleton: product.product(10, 11, 12)".

Abdullah

Autor

ok this is fixed to i just had to put an else and use @api.depends and multi. Thanks

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
Display a list of record in one field from order lines (V11) Rozwiązane many2one urgent related odoov11 Niyas	3 lip 22	7524
Related field not saving v8 related related_fields	2 kwi 24	9144
can we relate a field to a related field ? Rozwiązane fields related related_fields	1 mar 15	3739
Related field wrong value with multi-company related stock_move related_fields multi-company odoo12	1 maj 21	4438
Odoo(v11) Creation of asset based on quantity in invoice lines Rozwiązane create asset invoicing urgent odoov11	2 sty 20	3262

To pytanie dostało ostrzeżenie

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