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 vote163 views1 answer
How to form .cleaned data in class based views in django
Python Django
0 vote210 views1 answer
Django create object from dict
Python Django
0 vote175 views1 answer
Merge two Querysets in Python Django while preserving Queryset methods
Python Django
1 vote165 views2 answers
Join two querysets django
Python Django
1 vote166 views1 answer
Django celery results
Python Django
25 votes314 views2 answers
Create new django app
Python Django
1 vote168 views3 answers
Django reverse lazy
Python Django
0 vote176 views1 answer
Django data from many to many field in template
Python Django
0 vote164 views1 answer
What is *args and **kwargs in django
Python Django
0 vote119 views1 answer
Unique file name in django
Python Django