On Tue, 2008-03-04 at 07:28 -0800, Vincent Foley wrote: > Hello, > > I have a curious problem with a complex filter in 0.96: > > Merchant.objects.filter(Q(categories_fr__name__icontains=s) | > Q(categories_en__name__icontains=s)) > > this returns an empty queryset even when 's' is in categories_fr. > Changing categories_fr__name with an attribute directly in the object > has the same effect. It seems that a ManyToMany field with no > elements nullifies the entire query. > > Is this a bug, or am I misunderstanding something?
There are a few issues with many-to-many fields and empty results like this. The whole area has been given an overhaul in the queryset-refactor branch and so should be fixed on trunk soon-ish. In the meantime, just select the two halves individually and merge them in Python. Malcolm -- If it walks out of your refrigerator, LET IT GO!! http://www.pointy-stick.com/blog/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
