OR operator in Django model queries

Question

I'm trying to use an OR operator in the Django filter() function. Right now I have

contactlist = Contact.objects.filter(last_name__icontains=request.POST['query'])

but I also want to search by first name as well. For example:

contactlist = Contact.objects.filter(last_name__icontains=request.POST['query'] OR first_name__icontains=request.POST['query'])

Does anyone know how to do this?

possible duplicate of [Django Filters - or?](http://stackoverflow.com/questions/739776/django-filters-or) — e100, Mar 26 '15 at 17:46

score 125 · Accepted Answer · edited May 13 '14 at 15:39

125

Q objects

from django.db.models import Q

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

edited May 13 '14 at 15:39

Darian Moody

3,565
1
22
33

answered Mar 26 '11 at 20:49

Yuji 'Tomita' Tomita

115,817
29
282
245

score 13 · Answer 2 · answered Oct 28 '15 at 10:02

13

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

answered Oct 28 '15 at 10:02

Eric

147
1
3

6

Please state what you're fixing in here. Posting only code quotes without summary is forbidden on stackoverflow. – holms Oct 28 '15 at 17:32
1

Although I feel this syntax will force it to evaluate twice and so it'll execute two db queries instead of one (as described by the accepted answer) – strangetimes May 21 '17 at 16:56
2

For future reference, this syntax does NOT execute two database queries. – Jun 17 '18 at 19:42
is this going to be executed as a single SQL request? – Искрен Станиславов Jul 20 '18 at 12:38

OR operator in Django model queries

2 Answers2

Q objects

Linked

Related