Skip to Content
This question has been flagged
urgent@api.dependssingletonissueodoov11@api.multi
1 Reply
5292 Views
Avatar
Abdullah

hey! i've following line of code which is fetching value of prod_min_qty from stock.warehouse.orderpoint to product.template but it is giving me this singleton error. Can you suggest what should i use with it like @api.one,@api.multi,@api.depends and why? i'll be very thankful.


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
Avatar
Discard
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

Update the code like this,

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

or

def _get_min_qty(self):
    for prod_tml in self:
        product = self.env['product.product'].search([('product_tmpl_id', '=', prod_tml.id)], limit=1)
        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

Thanks

Avatar
Discard
Abdullah
Author

Hey man Thank you so much. It is working now. Can you kindly explain me this ? Also i am using @api.multi with it so it is fine right?

Niyas Raphy (Walnut Software Solutions)

This product = self.env['product.product'].search([('product_tmpl_id', '=', prod_tml.id)]) line is returning multiple values, so you have to iterate over a for loop to get single rec

Abdullah
Author

Ok Thank you soo much <3

Related Posts Replies Views Activity
Display a list of record in one field from order lines (V11) Solved
many2one urgent related odoov11 Niyas
Avatar
Avatar
3
जुल॰ 22
8061
Odoo(v11) Creation of asset based on quantity in invoice lines Solved
create asset invoicing urgent odoov11
Avatar
Avatar
2
जन॰ 20
3858
odoo(V11) Adding Bar code functionality in Assets Management Solved
asset barcode urgent barcodes odoov11
Avatar
Avatar
1
जन॰ 20
6142
Odoo(V11) web.basic_layout leaves empty space on the top of the page Solved
templates reporting urgent odoov11 web.basic
Avatar
Avatar
2
दिस॰ 19
9118
Odoo (v11) Fetch data of one field from one model to another Solved
urgent related related_fields odoov11 Inventory
Avatar
Avatar
3
दिस॰ 19
5479