On Tue, Jul 21, 2009 at 4:48 PM, caliman<stefanhjel...@gmail.com> wrote: > > How do you use django to use OR instead av AND when you use filter? > > Let's say I want: > SELECT * FROM table WHERE attrib1 IN (1,2,3) OR attrib2 IN (4,5,6) > > in django: > table.objects.filter(attrib1__in=[1,2,3]).filter(attrib2__in=[4,5,6]) > > this will be like: > SELECT * FROM table WHERE attrib1 IN (1,2,3) AND attrib2 IN (4,5,6) > > I want: > table.objects.filter(attrib1__in=[1,2,3] OR attrib2__in=[4,5,6]) > > >
You can use Q objects to do OR queries. http://docs.djangoproject.com/en/dev/topics/db/queries/#complex-lookups-with-q-objects Alex -- "I disapprove of what you say, but I will defend to the death your right to say it." -- Voltaire "The people's good is the highest law." -- Cicero "Code can always be simpler than you think, but never as simple as you want" -- Me --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
