I'm trying to get a queryset of all users in two particluar groups that *aren't* in a third particular group. Here's what I tried*:
User.objects.filter(groups__in=(author_group, guide_group)).exclude(groups=staff_group) This is the SQL produced: SELECT * FROM auth_user LEFT OUTER JOIN auth_user_groups ON auth_user.id = auth_user_groups.user_id WHERE auth_user_groups.group_id IN (5,3) AND NOT auth_user_groups.group_id = 1 The "AND NOT auth_user_groups.group_id = 1" clause has no effect on the query. What I want is something like: SELECT auth_user.id, auth_user.username, auth_user_groups.group_id FROM auth_user LEFT OUTER JOIN auth_user_groups ON auth_user.id = auth_user_groups.user_id WHERE auth_user_groups.group_id IN (5,3) AND auth_user.id NOT IN ( SELECT auth_user.id FROM auth_user LEFT OUTER JOIN auth_user_groups ON auth_user.id = auth_user_groups.user_id WHERE auth_user_groups.group_id = 1) Is there a solution for me that doesn't resort to raw SQL? Thanks in advance for helping me earn my Django queryset black belt. * There's currently a bug in Django which causes User.objects.filter(groups__name="staff") to fail, so my workaround is this: staff_group = Group.objects.get(name='staff') User.objects.filter(groups__name=staff_group) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
