django-filter and aggregate functions

Question

This is an app specific question: django-filter, here is a brief explanation for those who have not used it.

f = ProductFilter(request.GET, queryset=Product.objects.all())

This line does all the filtering for us. ProductFilter is a class, we have specified with filters (forms-alike class). f is a filter object (basically items we have asked for), which acts similar to a list.

Now, I'd like to perform aggregate functions (like Avg for instance) on this f object. Do you have any ideas how/if this could be accomplished?

mariodev · Accepted Answer · 2013-09-23 17:59:14Z

8

You mean something like this:

from django.db.models import Avg


class ProductFilter(django_filters.FilterSet):
    ...

    @property
    def avg(self):
        qs = super(ProductFilter, self).qs

        return qs.aggregate(Avg('price'))['id__avg']

So you're adding your own filter property and use it like this in your template:

{{ filter.avg }}

edited Sep 23, 2013 at 17:59

answered Sep 23, 2013 at 17:36

mariodev

15.7k4 gold badges56 silver badges66 bronze badges

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

1 Comment

nutship Over a year ago

You nailed it! Thx again

Collectives™ on Stack Overflow

django-filter and aggregate functions

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related