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 vote388 views1 answer
Run django app locally
Python Django
0 vote384 views1 answer
How to add column to heroku postgres in my django app
Python Django
1 vote378 views1 answer
Get csrf_token value in django template
Python Django
1 vote368 views2 answers
.save() in django
Python Django
0 vote386 views1 answer
Django command to fetch all columns of a table
Python Django
0 vote438 views1 answer
How to deploy to heroku djangorest framework app
Python Django
1 vote385 views1 answer
Django set default value for model not form
Python Django
2 votes328 views3 answers
No such table django
Python Django
0 vote338 views1 answer
Django builtin signals
Python Django
3 votes415 views2 answers
Update_or_create django
Python Django