Ahh ok. Something like this then? qset = (Q(tags__title__icontains=query) | Q(title__icontains=query)) results = Blog.objects.filter(qset).extra(LEFT OUTER JOIN tag ON blog.tag = tag.id)
On Mar 5, 10:49 pm, Pigletto <[EMAIL PROTECTED]> wrote: > > Basically, the queryset in views.py will ONLY return results if that > > particular Blog has a Tag related to it. If I haven't specified a tag > > for a particular blog, it will NEVER appear in my results. > > > Any ideas? Is my query only getting results with both a TITLE and > > TAG_TITLE? > > You need 'left outer join' here. SQL query build with django ORM > doesn't use that in this kind of query. > I think you may try to use .extra(....) to do it. > > -- > Maciej Wisniowski --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
