On 10 March 2010 12:06, jimgardener <jimgarde...@gmail.com> wrote: > Hi > I need to make a query as follows > Select all entries where categories=mycategory > > In the db there are entries and categories as follows > Category.objects.all() -->[ <Category: mycategory>,<Category: > hiscategory>,<Category: theircategory>] > > MyEntry.objects.all() --> [ <MyEntry: [u'mycategory']> ,<MyEntry: > [u'mycategory',u'hiscategory' ]>, <MyEntry: [u'theircategory']>] > > > I tried like this > mycategory=Category.objects.get(name='mycategory') > MyEntry.objects.filter(categories=mycategory) > > But this returns entries where the categories field contains > 'mycategory' and 'hiscategory' also. > How do I mention to retrieve only 'mycategory'. > > I went through the Queryset docs ..but couldn't figure it out... > Any help would be appreciated > thanks > jim > > > p.s: > > > My models are > class MyEntry(models.Model): > categories=models.ManyToManyField(Category) > > > class Category(models.Model): > name=models.CharField(unique=True,max_length=50) > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-us...@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > >
[ <MyEntry: [u'mycategory']> , <MyEntry: [u'mycategory',u'hiscategory' ]> Well that's what it is supposed to do, both Entry objects have relation to "mycategory". -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
