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

2 votes274 views2 answers
Numpy count where
Python
3 votes287 views3 answers
Simple jwt django
Python Django
-1 vote254 views1 answer
Py to flag converter online
Python
3 votes264 views3 answers
Use model from checkpoint tensorflow
Python
11 votes348 views4 answers
Cv2 rgb to bgr
Python
-1 vote259 views1 answer
Extracting values in pandas
Python
0 vote283 views1 answer
Train test validation sklearn
Python
1 vote273 views2 answers
Scikit learn r2 score
Python
2 votes268 views1 answer
Python buffer
Python
0 vote282 views1 answer
Cv2 put font on center
Python