On Mon, Jun 22, 2009 at 3:04 PM, IanR <ianrear...@gmail.com> wrote: > > I have a model with a ManyToManyField. I want to return all the > instances where this M2M field has specific instances of the table > that the M2M field points at. > > For example. Model.objects.filter(m2mfield__id=1,m2mfield__id=2), so > in theory this would return results in which the objects with primary > id=1 and primary id=2 were added to the models m2m field. However > this query always returns 0 results. (Looking at the raw SQL, it will > never turn any results because its looking for an impossible result, a > number with 2 values) > > I noticed that there is an "IN" function, Model.objects.filter > (m2mfield__in=[1,2]). However this returns instances when object 1 OR > 2 has been added. I want only instances where object 1 AND 2 have > been added. > > Any ideas? > > > Your problem is that when you do 2 filters on a multi-value relationship in a single filter() they operate on the same obj, but if you split them into seperate calls to filter() it will do just what you want:
Model.objects.filter(related_value__id=1).filter(related_value__id=2) Alex -- "I disapprove of what you say, but I will defend to the death your right to say it." --Voltaire "The people's good is the highest law."--Cicero --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
