0
378
Viewsdjango - how to sum values of the same key?
I want to sum the value of the count key if the values of year_taken have duplicates, how can I do that?
so the output would look like this
{'year_taken': '2019-2020', 'count': 1}, {'year_taken': '2021-2022', 'count': 3}
·
Santiago Trujillo
1 answers
Answer question0
You can try this:
from django.db.models import IntegerField, OuterRef, Subquery
class SQCount(Subquery):
output_field = IntegerField()
template = f"(SELECT count(*) from (%(subquery)s)) _count)"
subquery_count = SQCount(Subject.objects.filter(year_taken=OuterRef("year_taken")))
queryset = Subject.objects.annotate(count=subquery_count).order_by("year_taken").distinct("year_taken").values("year_taken", "count")
·
Santiago Trujillo
Report
Answer question