django many to many field annotate and count

Question

I have a model :
class Question(models.Model):
    user = models.ForeignKey(User)
    title = models.CharField(max_length=120)
    description = models.TextField()
    answers = models.ManyToManyField('Answer',related_name='answer_name', blank=True)

Here what I want is I want to list all the question which dont have any answer.

I did:

un_list = Question.objects.annotate(a_count="Answers").filter(a_count=0)

Is it right way of doing ?

dylrei · Accepted Answer · 2015-03-23 21:03:51Z

1

You're close. Here's what you probably want:

from django.db.models import Count
un_list = Question.objects.annotate(a_count=Count("answer")).filter(a_count=0)

answered Mar 23, 2015 at 21:03

dylrei

1,74610 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

django many to many field annotate and count

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related