How to get more than one field with django filter icontains

Question

I am trying to compare my query search to all my model fields, but I can't figure how to do it in more than one field.

this is my code.

expense = Expense.objects.filter(user=request.user.id).order_by('date')

q = request.GET['q']
result = expense.filter(name__icontains=q)

I want to check in: name, amount, category

Thanks in advance

If amount is an integer, you will probably won't want to use icontains, but a regular lookup. — Udi, Feb 23 '13 at 20:24

jurgenreza · Accepted Answer · 2013-02-23T20:23:57.553

20

From Django documentation:

"Keyword argument queries – in filter(), etc. – are “AND”ed together. If you need to execute more complex queries (for example, queries with OR statements), you can use Q objects."

from django.db.models import Q
expense.objects.filter(
    Q(name__icontains=q) | Q(amount__icontains=q) | Q(category__icontains=q)
)

I'm not sure about the type of amount and category in your model so icontains may not work on them.

see this link.

edited Feb 23 '13 at 20:23

answered Feb 23 '13 at 20:18

jurgenreza

5,856
2
25
37

1

You should use filter instead of get, because get return only one object. – UnLiMiTeD Feb 23 '13 at 20:27
You're right about category, maybe because its a foreign key? – yaniv14 Feb 23 '13 at 20:43
2

if it is a foreign key you could access the name field with double underlines: category__name__icontains for example. – jurgenreza Feb 23 '13 at 20:45

How to get more than one field with django filter icontains

1 Answers1

Linked