Sounds like what you want is something like: MyCategories = Category.objects.exclude(name!='mycateogry')
only problem is, django doesn't support the != operator so you're going to have to go with a query object: add this to your view from django.db.models import Q (importing the Q object http://docs.djangoproject.com/en/dev/topics/db/queries/#complex-lookups-with-q-objects, here's another good article on Q objects http://www.djangozen.com/blog/the-power-of-q) mycategory=Category.objects.exclude(~Q(name='mycategoy') (the ~Q is equivalent to "this query DOES NOT EQUAL) I don't have a model like this set up anywhere so I don't know if this will properly filter those results with both 'mycategory' and other categories as well. On Mar 10, 6:24 am, rebus_ <r.dav...@gmail.com> wrote: > 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 > > athttp://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.
