How to Solve this problem

Question

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

Jos De Graeve · Accepted Answer

Hi,

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

The operation of  groupby() [1]  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

[1] https://docs.python.org/2/library/itertools.h

mostafa · Answer

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

Bài viết liên quan	Trả lời	Lượt xem
How to get value from DB in constructor? database orm python2.7	0 thg 10 16	4274
Error occurred during the installation of loan management(V6.1) module in V7.0 python2.7	3 thg 10 23	6203
How to write a python function called automatically? python2.7	2 thg 1 23	5590
Datetime in python Đã xử lý python2.7	7 thg 6 21	24875
raise ValueError(“Expected singleton: %s” % self) when return more than one record Đã xử lý orm refund python2.7 odoo10	1 thg 12 19	6201

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!