How to search multiple keywords over multiple columns in Django

How to search for multiple keywords over multiple columns in Django. Seach a list values in Multipal columns.

search in multiple colum image


#search query

from django.db.models import Q

def search(request):

    list_ = ["searchterm1", "searchterm2", "searchtermN"]

    q_object = Q(title__icontains=list[0]) | Q(description__icontains=list[0])

    for item in list_[1:]:
        q_object.add((Q(title__icontains=item) | Q(description__icontains=item)), q_object.connector)

    queryset = Product.objects.filter(q_object)



reference


We belive you
like this pealse comment if any issues

Comments