searching all fields in a table in django

Question

How to search all fields in a table in django using filter clause ex:table.object.filter(any field in the table="sumthing")

Thanks.

Answer 1

I don't think the filter clause is suited to this kind of search. You might want to check out Haystack.

Answer 2

I agree with Alasdair, but the answer to your question is this though:

from django.db.models import CharField
from django.db.models import  Q

fields = [f for f in table._meta.fields if isinstance(f, CharField)]
queries = [Q(**{f.name: SEARCH_TERM}) for f in fields]

qs = Q()
for query in queries:
    qs = qs | query

table.objects.filter(qs)

note: I have not tested this code, but it should get you quite a bit close to your goal