ManyToMany fields in database lookups

2008-03-04 Thread Vincent Foley
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 obje

Re: ManyToMany fields in database lookups

2008-03-04 Thread Malcolm Tredinnick
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 categorie