Use Count with aggregate(Sum) in django ORM, Custom Queryset Fields

Question

I want to use query in which I need No of Invoices and Total Amount of Invoices in a Queryset.

Invoice.objects.aggregate(total_amount=Sum('order__order_items__amount')) 
Invoice.objects.count()

How can I handle above queries in a single query.

willeM_ Van Onsem · Accepted Answer · 2022-06-27 06:30:26Z

2

You can count the number of distinct primary keys:

from django.db.models import Count, Sum

Invoice.objects.aggregate(
    total_amount=Sum('order__order_items__amount'),
    number_of_invoices=Count('pk', distinct=True)
)

This will return a dictionary with 'total_amount' and 'number_of_invoices' as keys.

answered Jun 27, 2022 at 6:30

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

I'mSRJ Over a year ago

and how can i use filter with this

willeM_ Van Onsem Over a year ago

@I'mSRJ: how are you filtering?

I'mSRJ Over a year ago

i want to filter like this ---> queryset.filter(order__owner=request.user) but your answer is returning dictionary then how can i do it.

I'mSRJ Over a year ago

ohk i got it---> Invoice.objects.filter(order__owner=request.user).aggregate(total_amount=Sum('order__order_items__amount'),number_of_invoices=Count('pk', distinct=True)) but is there a way that how can I get a queyset as your answer is returning dict

Collectives™ on Stack Overflow

Use Count with aggregate(Sum) in django ORM, Custom Queryset Fields

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related