Hi, 

i'm new in odoo 10 and i need some help :)

I would like to know , for each product in stock picking , how many picking quantity i have for a  location_id given .With this result i would like to create a list view ordered by picking_quantity.  It will be a new view ​

In fact i would like to create this request and create its view associated

SELECT product_id, sum(ordered_qty) as nb
FROM public.stock_pack_operation
inner join public.stock_picking on public.stock_picking.id = public.stock_pack_operation.picking_id
where public.stock_picking.picking_type_id=4 and public.stock_picking.location_id=15
group by product_id
order by nb desc
;

Is it possible to to that? Do i need to create a new model for this list? 

Thanks a lot for your help

Thomas