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
-~----------~----~----~----~------~----~------~--~---
