Skip to Content
Menu
This question has been flagged
2 Replies
3599 Views

Hi all 

i need to know what is the error in this code 

%for product, lines in groupby(trip.order_lines, lambda l : l.product_id.name) :
      <% qt = int(sum([l.qty for l in lines])) %>

 

i try to get the sm of all product quantity , but i didn't get it i get product and thier quantity not gruoped 
what can i do 

Avatar
Discard
Best Answer

Hi,

Have you checked that your list trip.order_lines is sorted by product ?

The operation of groupby() is similar to the uniq filter in Unix. It generates a break or new group every time the value of the key function changes (which is why it is usually necessary to have sorted the data using the same key function). That behavior differs from SQL’s GROUP BY which aggregates common elements regardless of their input order.

Regards,

Jos

 

Avatar
Discard
Author Best Answer

@Jos De Graeve , tanks alot it worked fine with me 

Avatar
Discard
Related Posts Replies Views Activity
0
Oct 16
4068
3
Oct 23
5769
2
Jan 23
5116
7
Jun 21
24451
1
Dec 19
5989