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

1 vote335 views1 answer
Django.db.models avg
Python Django
0 vote391 views1 answer
Lose your django secret key
Python Django
0 vote440 views1 answer
How to set default user group in django
Python Django
0 vote467 views1 answer
Aggregation with f() in django rest api
Python Django
10 votes378 views1 answer
Https://docs.djangoproject.com/en/2.0/howto/static-files/
Python Django
0 vote358 views1 answer
Smtp django
Python Django
13 votes427 views6 answers
Django orm
Python Django
-2 votes354 views4 answers
Django form datepicker
Python Django
1 vote378 views1 answer
Display category field in django admin
Python Django
0 vote393 views1 answer
How to add column to heroku postgres in my django app
Python Django