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 vote233 views1 answer
Auto-created primary key used when not defining a primary key type, by default 'django.db.models.AutoField'.
Python Django
2 votes240 views2 answers
Django regexvalidator example
Python Django
1 vote245 views3 answers
Accessing data on django sessionstore
Python Django
0 vote223 views1 answer
Django post request 403 forbidden
Python Django
0 vote218 views1 answer
Add many instances to related field manytoamny django]
Python Django
2 votes244 views1 answer
Pass in queryset as filter django
Python Django
1 vote252 views1 answer
Django migrate fake zero
Python Django
1 vote299 views2 answers
Convertir datetime to timestamp django
Python Django
1 vote247 views1 answer
Django foreign key error Cannot assign must be a instance
Python Django
1 vote229 views1 answer
Run django app locally
Python Django