Django sum get 0 if none

from django.db.models.functions import Coalesce

answers = Answer.objects.filter(<something here>)
                        .annotate(score=Coalesce(Sum('vote__type'), 0))
                        .order_by('-score')

Source: stackoverflow.com

Django sum get 0 if none

answers = Answer.objects.filter(<something here>)
                        .annotate(score=Coalesce(Sum('vote__type'), 0))
                        .order_by('-score')

Source: stackoverflow.com

Similar codes

0 vote192 views1 answer
Django collectstatic with auto yes
Python Django
2 votes195 views1 answer
Django filter multiple fields
Python Django
4 votes299 views1 answer
Create or update django models
Python Django
0 vote198 views1 answer
Django content type for model
Python Django
0 vote223 views1 answer
Aggregation with f() in django rest api
Python Django
4 votes193 views2 answers
Django how to delete a db field
Python Django
0 vote263 views1 answer
Merge two query sets django
Python Django
2 votes297 views3 answers
No such table django
Python Django
0 vote208 views1 answer
What is NoReverseMatch in django?
Python Django
-1 vote199 views2 answers
How to url encode using python django
Python Django