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 vote370 views1 answer
How to migrate from sqlite to postgresql django
Python Django
0 vote380 views1 answer
How to compress image field in django?
Python Django
0 vote408 views1 answer
Field 'id' expected a number but got <django.db.models.fields.related_descriptors.create_forward_many_to_many_manager.<locals>.ManyRelatedManager object at 0x7fb02044de80>
Python Django
1 vote366 views5 answers
How to install django in virtual environment in ubuntu
Python Django
0 vote403 views1 answer
How to console log in django heroku
Python Django
3 votes401 views2 answers
Update_or_create django
Python Django
6 votes343 views2 answers
How to check if django is installed( in python shell)
Python Django
6 votes341 views5 answers
Django logout
Python Django
1 vote371 views1 answer
Django model query add annotation field to show duplicate count
Python Django
-1 vote348 views1 answer
Raw query in django
Python Django