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 vote187 views1 answer
Django queryset all objects
Python Django
0 vote210 views1 answer
Django.db.utils.IntegrityError: column contains null values
Python Django
0 vote187 views1 answer
What is *args and **kwargs in django
Python Django
4 votes199 views3 answers
Django Change Password
Python Django
0 vote191 views1 answer
Django less than and greater than
Python Django
9 votes177 views2 answers
Django import Q
Python Django
0 vote219 views1 answer
Django get current user in form
Python Django
30 votes227 views6 answers
How to create a superuser in django
Python Django
-1 vote191 views1 answer
Set form field disabled django
Python Django
5 votes200 views2 answers
Get_object_or_404 django
Python Django