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 vote182 views1 answer
ImportError: cannot import name 'FieldDoesNotExist' from 'django.db.models.fields' (C:\Users\Admin\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\fields\__init__.py)
Python Django
15 votes232 views4 answers
Django python install
Python Django
0 vote175 views2 answers
How to get current page url in django template
Python Django
0 vote186 views1 answer
Make value of two tables unique django
Python Django
3 votes178 views1 answer
No module named 'django.core.urlresolvers'
Python Django
1 vote217 views1 answer
Django __str__ self multiple
Python Django
1 vote185 views1 answer
Cookies in django
Python Django
-2 votes211 views1 answer
Start django project in windows
Python Django
0 vote205 views1 answer
Django model plural
Python Django
19 votes201 views6 answers
Install Django in Windows
Python Django

Django sum get 0 if none

Django sum get 0 if none

Django sum get 0 if none

ImportError: cannot import name 'FieldDoesNotExist' from 'django.db.models.fields' (C:\Users\Admin\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\fields\init.py)

Django python install

How to get current page url in django template

Make value of two tables unique django

No module named 'django.core.urlresolvers'

Django str self multiple

Cookies in django

Start django project in windows

Django model plural

Install Django in Windows