I believe it would be: Thing.objects.all().exclude(property__property_type__exact = type).distinct()
-rfd On Aug 28, 12:24 pm, James Tauber <[EMAIL PROTECTED]> wrote: > There's another query I want to do that I can't seem to wrap my head > around at the moment: > > Say I have a model where Things have Properties each of a particular > PropertyType. So > > class Property(models.Model): > > thing = models.ForeignKey(Thing) > property_type = models.ForeignKey(PropertyType) > value = models.CharField(...) > ... > > I want to find, for a given PropertyType, all the Things that are > lacking any Property of that type. > > Like my previous question, in SQL I could do it with an EXCEPT: > > SELECT id > FROM myapp_thing > EXCEPT > SELECT thing_id > FROM myapp_property > WHERE property_type_id = ... > > How can I best do these sorts of EXCEPT queries with the database API? > > James --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
