I only want records that have both the terms, "ThemePark" AND "London"
The attribute of Terms that contains 'ThemePark' and 'London is simply
'term'
The full model is:
class Terms(models.Model):
term=models.CharField(maxlength=100,core=True,help_text="search
term")
def __unicode__(self):
return self.search_term
class Offer(models.Model):
searchterms=models.ManyToManyField(Terms,blank=True)
On Sep 17, 1:52 am, r_f_d <[EMAIL PROTECTED]> wrote:
> Couple of things so I understand better,
> What is the attribute of term that contains 'ThemePark' and 'London' ?
> What are you trying to end up with, all records with themePark or only
> records with themepark and London ?
> -richard
>
> On Sep 16, 11:36 am, merric <[EMAIL PROTECTED]> wrote:
>
> > I can't get this to work for me.
>
> > For example, I have two records which both share the term 'ThemePark",
> > one of these records also has the additional term "London".
> > However, when I run your suggestion I get an empty query set.
>
> > Cheers
>
> > On Sep 15, 2:27 am, r_f_d <[EMAIL PROTECTED]> wrote:
>
> > > You are missing Q.
>
> > > try
> > > from django.db.models import Q (I think that is where it resides but
> > > cannot verify right now, a quick check of the documentation should
> > > confirm)
>
> > > Offer.objects.filter(Q(terms__exact = 'term1') & Q(terms__exact =
> > > 'term2') & Q(terms__exact = 'term3))
>
> > > On Sep 14, 6:46 pm, Merric Mercer <[EMAIL PROTECTED]> wrote:
>
> > > > I have a model "OFFER" that has has many to many relationship with a
> > > > model "TERMS".
>
> > > > Class OFFER:
> > > > terms=models.ManyToMany(Terms)
>
> > > > Assuming I have the following value for 3 records in Term
> > > > term1=2
> > > > term2=5
> > > > term3=8
>
> > > > I want to return ONLY those offers which have ALL three of these terms .
> > > > I've tried:
>
> > > > qs=Offer.objects.all().filter(terms=term1).filter(terms=term2).filter(terms=term3)
> > > > but this doesn't work - I always end up with an empty query set.
>
> > > > What am I missing?
>
> > > > Cheers
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
