Get unique elements in an array and add the value if same element is found - django

Asked Nov 07 '22 at 14:45

Active Nov 07 '22 at 14:45

Viewed 29 times

<QuerySet 
    [{'product': 6, 'quantity': 1}, 
    {'product': 6, 'quantity': 10}, 
    {'product': 7, 'quantity': 2}, 
    {'product': 9, 'quantity': 3}]
>

how to get unique elements only in the array and add the quantity if same product is found. In the above eg: there are two "product: 6", so the new QuerySet should be

<QuerySet 
    [{'product': 6, 'quantity': 11}, 
    {'product': 7, 'quantity': 2}, 
    {'product': 9, 'quantity': 3}]
>

asked Nov 07 '22 at 14:45

beck

2,967
3
16
27

Which database backend are you using? Postgres? – Mihai Chelaru Nov 07 '22 at 14:47
1

Does this answer your question? [How to query as GROUP BY in django?](https://stackoverflow.com/questions/629551/how-to-query-as-group-by-in-django) – Zkh Nov 07 '22 at 15:19
@MihaiChelaru sqlite3 (default)... I've just started using django... – beck Nov 12 '22 at 08:15

Get unique elements in an array and add the value if same element is found - django

0 Answers0