Django 2.0 (2017-12-02)

See also

• https://docs.djangoproject.com/en/dev/releases/2.0/

• https://docs.djangoproject.com/en/dev/ref/models/conditional-expressions/

• Aggregation with filter (Django 2.0+) by Haki Benita

Aggregation with filter

See also

• https://docs.djangoproject.com/en/dev/releases/2.0/

• Aggregation with filter (Django 2.0+) by Haki Benita

In Django 2.0 a filter argument to aggregate functions was added to make this a lot easier:

from django.contrib.auth.models import User
from django.db.models import Count, F

User.objects.aggregate(
    total_users=Count('id'),
    total_active_users=Count('id', filter=F('is_active')),
)

Nice, short and sweet.