Odoo Help


How can you get a list of all product_id's associated to a given a stock_picking id?

on 1/27/16, 3:14 PM 811 views

If you have a given ID for a stock_picking, what should be done to get all product_id's associated to that stock_picking?    

Axel Mendoza
On 1/27/16, 4:11 PM

You could do it like this:

prod_ids = [move.product_id.id for line in self.env['stock.move'].search([('picking_id', '=', picking_id)])]


prod_ids = [move.product_id.id for line in self.env['stock.move'].search([('picking_id', '=', id)])] AttributeError: 'Binary' object has no attribute 'env' (**** this is used inside class Binary(http.Controller): *****)

on 1/28/16, 4:27 AM
On 1/28/16, 4:13 AM

Thanks Axel, and why do I need this in a controller method? I see that given the ID I could follow your path.

Model = request.registry['stock.picking']

cr, uid, context = request.cr, request.uid, request.context

fields = [ 'id' ]

res = Model.read(cr, uid, [int(id)], fields, context)[0]

I don't understand you correctly but if you need to find the product_id for a given picking_id in a controller you could do it as I show you with the registry of models. I don't know that you need it to use it in a controller when I answer you but it's the same.

Axel Mendoza
on 1/28/16, 9:38 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 1/27/16, 3:14 PM
Seen: 811 times
Last updated: 1/28/16, 4:13 AM