I am trying to retrieve a couple of records from my table of production to perform a calculation.
So far I have this class that extends mrp.production.workcenter.line
for work_order in self.browse(cr, uid, ids, context=None):
ids_product_qty = self.pool.get('mrp.bom').search(cr, uid, ['routing_id', '=', work_order.routing_id], limit=1, context=None) ids_hour_prd = self.pool.get('mrp.routing.workcenter').search(cr, uid, ['routing_id', '=', work_order.routing_id], limit=1, context=None) product_qty_by_hour = mrp_bom_object.browse(cr, uid, ids_product_qty, context=None) hour_product = mrp_routing_workcenter_object.browse(cr, uid, ids_hour_prd, context=None) result[work_order.id] = (hour_product.hour_nbr * work_order.qty) / product_qty_by_hour.product_qty
But is not working, and in debugging it shows that the ids return empty lists. Someone has any idea why?
Thanks a lot.
For me you should use like this (you missed ".id" on your domain definition):
ids_product_qty = self.pool.get('mrp.bom').search(cr, uid, ['routing_id', '=', work_order.routing_id.id], limit=1, context=None)
I have not create a test database to check but think it'is the correct way.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 6/12/13, 12:57 PM|
|Seen: 846 times|
|Last updated: 3/16/15, 8:10 AM|