Did you mean or(|) instead of and(&)? I need SQL UNION for efficiency reasons (using UNION instead of SQL generated by models.Advertisement.objects.filter( Q(company__name__search="test") | Q(contact__phone__istartswith="8495") is 60x faster in my case)
On Sep 17, 7:51 pm, Daniel Roseman <dan...@roseman.org.uk> wrote: > On Sep 17, 3:39 pm, blumenkraft <vohs...@gmail.com> wrote: > > > Hi, > > > I have two querysets: > > x = models.Advertisement.objects.filter(company__name__search = > > "test") > > y = models.Advertisement.objects.filter(contact__phone__istartswith = > > "8495") > > > Is there any simple way to get union (using SQL UNION clause) of these > > querysets? > > Use Q() objects: > > from django.db.models import Q > union = models.Advertisement.objects.filter( > Q(company__name__search="test") & > Q(contact__phone__istartswith="8495") > ) > > -- > DR. --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
