This question has been flagged
4 Replies
3067 Views
reportstudioodoo12
Avatar
Yeison X

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
Avatar
Atul Patel (atp)
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
Avatar
Yeison X
Author Best Answer

Hi Walled, 

Could you tell me where I can find (key=None, reverse=False) parameter?

Thanks for your help.

Avatar
Discard
Waleed Ali Mohsen

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">

Avatar
Waleed Ali Mohsen
Best Answer

You can use sorted(key=None, reverse=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