Get delivery orders based on warehouseID

Question

Hi all. Like the title, I am wondering how I can get delivery orders from stock.picking based on the warehouse_id in Odoo 12. My code is currently like this:
delivery_orders = self.env['stock.picking'].search(['&', ('state', '=', 'assigned'), ('warehouse_id', '=', warehouse_id)]).mapped('id')
But of course it does not work because there is no warehouse_id field in stock.picking. If anyone knows the answer, please let me know and many thanks in advance.

Equick ERP · Accepted Answer

Hello
warehouse id is available on the stock picking type.
so instead of use warehouse_id in stock picking use the picking_type_id.warehouse_id in your search.
like
self.env['stock.picking'].search(['&', ('state', '=', 'assigned'), ('*picking_type_id.warehouse_id*', '=', warehouse_id)]).mapped('id')
Hope this will helps you.

Powiązane posty	Odpowiedzi	Widoki
how to get how many not delivered product backorder and how many (Done ) delivered stock_picking stock.picking delivery_order	0 kwi 19	2553
Odoo only picking one Warehouse for Delivery orders warehouses operation deliveryorder delivery_order	0 paź 23	1458
Create delivery orders based on warehouses odoo16 warehouses sale delivery_order odoo16features	1 mar 23	2259
Is it possible to mass validate orders that have been turned to delivery? Rozwiązane delivery_order	1 sty 25	1491
what is procurement Rozwiązane warehouses	4 lut 25	17724

To pytanie dostało ostrzeżenie

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