Skip to Content
Menu
This question has been flagged
4 Replies
3247 Views

Hi, thanks in advance for your help.

The Delivery Slip report (WH / IN or WH / OUT) organizes the products by Lot and not by reference. Example:

Product description          Lot 
Product 1                            L001 
Product 2                            L001 
Product 1                            L002 
Product 2                            L002 

I would like the report to go like this: 


Product description               Lot 
Product 1                                 L001
Product 1                                 L002
Product 2                                 L001
Product 2                                 L002

I am using Odoo Studio. Odoo V12

Thanks!

Avatar
Discard
Best Answer

Hello,

Have you tried like this way in report qweb template :

https://github.com/odoo/odoo/blob/4909e87cd463c3bedcf096e0535ec90d829aa491/addons/stock/report/report_stockpicking_operations.xml#L91

for example : 

o.move_ids_without_package.sorted(key=lambda m: m.product_id.id)" t-as="move" that will sort move lines by product id.

You can use like that way to sort record by pass that field as key on lambda..

Thanks 


Avatar
Discard
Author Best Answer

Hi Walled, 

Could you tell me where I can find (key=Nonereverse=False) parameter?

Thanks for your help.

Avatar
Discard

For example if you want to sort by product name and then by qty:

<tr t-foreach="lines.sorted(key=lambda p: (p.product_id.name, p.product_uom_qty))" t-as="move">

Best Answer

You can use sorted(key=Nonereverse=False)

Parameters

  • key – either a function of one argument that returns a comparison key for each record, or a field name, or None, in which case records are ordered according the default model’s order
  • reverse – if True, return the result in reverse order



Avatar
Discard
Related Posts Replies Views Activity
1
Mar 24
1382
3
Dec 20
1922
2
Sep 20
2055
1
Feb 20
2135
0
Nov 19
8