Django QuerySet filter method returns multiple entries for one record
Posted
by Yaroslav
on Stack Overflow
See other posts from Stack Overflow
or by Yaroslav
Published on 2010-04-16T15:40:56Z
Indexed on
2010/04/16
15:43 UTC
Read the original article
Hit count: 587
Trying to retrieve blogs (see model description below) that contain entries satisfying some criteria:
Blog.objects.filter(entries__title__contains='entry')
The results is:
[<Blog: blog1>, <Blog: blog1>]
The same blog object is retrieved twice because of JOIN performed to filter objects on related model. What is the right syntax for filtering only unique objects?
Data model:
class Blog(models.Model):
name = models.CharField(max_length=100)
def __unicode__(self):
return self.name
class Entry(models.Model):
title = models.CharField(max_length=100)
blog = models.ForeignKey(Blog, related_name='entries')
def __unicode__(self):
return self.title
Sample data:
b1 = Blog.objects.create(name='blog1')
e1 = Entry.objects.create(title='entry 1', blog=b1)
e1 = Entry.objects.create(title='entry 2', blog=b1)
© Stack Overflow or respective owner