Using OR operation in Django query

Question

HI i am trying to use OR operator in django query. my code looks like:

hotels = models.Hotel.objects.filter(
        wed=True,
        county=hotel_main.county.id,
        (x=True)|(y=True)|(z=True),
        subscriptions__end_date__gte=datetime.date.today(),
        subscriptions__enquiry_count__lte=F('subscriptions__tier__enquiry_limit'),
    ).distinct()

I am trying to fetch a record having atleast one of the above x, y, z as true. Any help ...thank you

possible duplicate of Django Filters - or?

e100
– e100

2015-03-26 17:55:39 +00:00
Commented Mar 26, 2015 at 17:55 — e100
– e100, Commented Mar 26, 2015 at 17:55

karthikr · Accepted Answer · 2012-09-17 14:22:55Z

2

You would have to use the Q object. Something like this:

hotels = models.Hotel.objects.filter(
    wed=True,
    county=hotel_main.county.id,
    subscriptions__end_date__gte=datetime.date.today(),
    subscriptions__enquiry_count__lte=F('subscriptions__tier__enquiry_limit')).filter( Q(x=True) | Q(y=True) | Q(z=True)).distinct()

answered Sep 17, 2012 at 14:22

karthikr

100k26 gold badges208 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:43:37Z

2

Q objects

Contact.objects.filter(Q(last_name__icontains=request.POST['query']) | 
                           Q(first_name__icontains=request.POST['query']))

REF: OR operator in Django model queries

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Sep 17, 2012 at 14:22

Vivek S

5,5608 gold badges57 silver badges74 bronze badges

4 Comments

Jharwood Over a year ago

Both answers are right, but this one uses references and so should be accepted

Vivek S Over a year ago

yeah, move your Q statements to the last

karthikr Over a year ago

@Jharwood the above answer uses reference too .. Hower over Q

Jharwood Over a year ago

oh, it wasn't obvious it was a link

Collectives™ on Stack Overflow

Using OR operation in Django query

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related