도움말

0

Sort products by reference not by lot - Delivery Slip

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!

아바타
작성취소
4 답변
0
최고의 답변

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 


아바타
작성취소
0
Avatar
Yeison X
최고의 답변

Hi Walled, 

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

Thanks for your help.

1 댓글
아바타
작성취소
Avatar
Waleed 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">

0
Avatar
Waleed Mohsen
최고의 답변

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



아바타
작성취소