I have a query similar to the following:
SELECT SUM(ISNULL(table.name)) FROM table
How to convert SUM to QuerySet in Django? (That is, why does the xyz conversion operate, such as MyModel.objects.xyz()
?)
from django.db.models import Sum
ModelName.objects.filter(field_name__isnull=True).aggregate(Sum('field_name'))
How sum works:
ModelName.objects.aggregate(Sum('field_name'))