Re: many-to-many queryset question

One possibility is to try two excludes.

bad_authors = Authors.objects.exclude(pk__in=SetOfAuthors)

qs = Entry.objects.exclude(authors__in=bad_authors)

This will return all entries that don't have authors in SetOfAuthors. It might even be easier, if you can skip creating SetOfAuthors in the first place.

On Dec 6, 2011, at 12:19 PM, Felipe Morales wrote:

could you possibly show the query generated?... 

# print qs.query

2011/12/6 Carsten Fuchs <carsten.fuchs@cafu.de>

Hi all,

looking at the example models Author and Entry at https://docs.djangoproject.com/en/1.3/topics/db/queries/, I would like to run a query like this:

       SetOfAuthors = Authors.objects.filter(...)
       qs = Entry.objects.filter(authors__in=SetOfAuthors)

such that (pseudo-code):

       for e in qs:
               "e.authors is a subset of (or equal to) SetOfAuthors"

However, when I try it, the true result seems to be an intersection:

       for e in qs:
               "There is (at least one) an author in e.authors that is also in SetOfAuthors"


How do I have to phrase the query in order to obtain only entries whose authors are all in SetOfAuthors?

Best regards,
Carsten



--
  Cafu - the open-source Game and Graphics Engine
for multiplayer, cross-platform, real-time 3D Action
         Learn more at http://www.cafu.de

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

--
Felipe Morales C.
Ingenierío de Ejecución en Computación e Informática.

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

Peter of the Norse

RahmCoff@Radio1190.org